Skip to Content
It is currently November 19th, 2019, 11:13 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
PostPosted: May 28th, 2011, 12:53 pm 
Offline
New User
New User

Joined: June 12th, 2009, 2:00 pm
Posts: 18
hello i'm french sorry for my english,

i want display dedication in playing.php with buble special script but, i can't display from database request !

this is my script :


Code:
$db->open("SELECT requestlist.*,songlist.artist,songlist.title,songlist.duration FROM requestlist LEFT JOIN songlist ON requestlist.songid=songlist.id $where ORDER BY requestlist.id DESC");


Code:
<div>
<? if($song["requestid"]>=1){?>
<? echo $song["name"];?>
<? echo $song["msg"];?>
<? };?>
</div>


but no message and name !

please help me !

Thanks for all


Top
 Profile  
Reply with quote  
PostPosted: May 28th, 2011, 11:23 pm 
Offline
SVS Member
SVS Member

Joined: October 15th, 2003, 11:59 pm
Posts: 4732
Location: Los Angeles - A Little West Of Nashville
Your PHP code is incorrect.

I haven't tested this, but it should look something like this:

Code:
<div>
<? if($song["requestid"]>=1){echo $song["name"];echo $song["msg"];}; ?>
</div>

_________________
- DJ Dee
- Spacial Volunteer Support (SVS)
- Custom PAL services: www.palscripts.com
- http://www.AlternativeHD.com
- http://www.lahotcountry.com


Top
 Profile  
Reply with quote  
PostPosted: May 29th, 2011, 10:59 am 
Offline
New User
New User

Joined: June 12th, 2009, 2:00 pm
Posts: 18
hello and thanks for this...

but dedication is blank...

doesn't work for me...

result here :

http://disneyweb.ath.cx/samhits


Top
 Profile  
Reply with quote  
PostPosted: May 30th, 2011, 6:56 am 
Offline
New User
New User

Joined: June 12th, 2009, 2:00 pm
Posts: 18
i test this :

Code:
$db->open("SELECT name, msg, t_stamp FROM requestlist, songlist  WHERE (requestlist.name=requestlist.name) AND (requestlist.songID=songlist.ID) AND (requestlist.status=requestlist.status) ORDER BY requestlist.ID DESC");
$test= $db->row();


with :

Code:
<div>
? if($song["requestid"]>=1){echo $test["name"];echo $test["msg"];}; ?>
</div>


but is always same dedication to dispay in list !!!


Top
 Profile  
Reply with quote  
PostPosted: May 30th, 2011, 7:34 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10450
Location: Denver, CO
The first thing you should do is to make sure the msg field is actually being updated from your dedication entry. Have you verified that the msg is actually there by querying the database table requestlist directly with an mysql query tool?

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: May 31st, 2011, 12:28 am 
Offline
New User
New User

Joined: June 12th, 2009, 2:00 pm
Posts: 18
:arrow: sorry but I do not understand (french translate in google ) ...

have you example ?

i want display lasts dedication in buble in playing.php and playlist.php with combine and pictures in list

songID=RequestID oder by artist, title (playlist.php)

SongID=Last Request (playing.php)

ex:


Attachments:
dedication3.jpg
dedication3.jpg [ 82.47 KiB | Viewed 2105 times ]
dedication2.jpg
dedication2.jpg [ 85.18 KiB | Viewed 2105 times ]
dedication1.jpg
dedication1.jpg [ 85.49 KiB | Viewed 2105 times ]
Top
 Profile  
Reply with quote  
PostPosted: April 2nd, 2019, 3:36 am 
Offline
Junior User
Junior User

Joined: January 21st, 2013, 9:33 pm
Posts: 33
I have been playing around with this code as well, where if a user does in fact add their name in the name and dedication boxes to show in the now playing-Coming up, In my case it does show the NAME and if dedicated in the requestlist table, but I too have the same result, where it shows the username after every song in "coming up". I tried a bunch of different ways to call it up but always same result, just can't seem to narrow it down to only the song that was added the name.

_________________
Never a dull moment at MIXROCKMETAL.COM ~ UP THE IRONS \m/


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group