It is currently July 6th, 2022, 7:33 am

View unanswered posts | View active topics


Board index » Software » SAM Broadcaster » Web Features

All times are UTC - 6 hours [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 7 posts ] 
  Previous topic | Next topic 
Author Message
msprod
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  
countrywesterndj
PostPosted: May 28th, 2011, 11:23 pm 
Offline
SVS Member
SVS Member

Joined: October 15th, 2003, 11:59 pm
Posts: 4744
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  
msprod
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  
msprod
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  
DJ Cassio
PostPosted: May 30th, 2011, 7:34 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10571
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  
msprod
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 7018 times ]
dedication2.jpg
dedication2.jpg [ 85.18 KiB | Viewed 7018 times ]
dedication1.jpg
dedication1.jpg [ 85.49 KiB | Viewed 7018 times ]
Top
 Profile  
Reply with quote  
armor
PostPosted: April 2nd, 2019, 3:36 am 
Offline
Junior User
Junior User

Joined: January 21st, 2013, 9:33 pm
Posts: 34
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  Page 1 of 1
  [ 7 posts ] 

Board index » Software » SAM Broadcaster » Web Features

All times are UTC - 6 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 25 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:  
cron
Powered by phpBB® Forum Software © phpBB Group