Skip to Content
It is currently May 25th, 2020, 2:20 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: October 15th, 2008, 8:45 am 
Offline
SVS Member
SVS Member

Joined: May 5th, 2008, 4:53 pm
Posts: 304
Hi all,

i would like to show the song that currently started playing just if its in "S" songtype.
With PAL script its clear but not how to do it with HTML output.
How to show just if songtype "S" and is it the right way how to use the db query?

Thanks

Code:
<!--LOOP(query,"SELECT * FROM songlist ORDER BY date_played DESC limit 1")-->
<!--LOOP_HEADER-->
<!--LOOP_ROW-->
Artist: $query.artist$  Title:  $query.title$
<!--LOOP_FOOTER-->
<!--LOOP_END-->

_________________
Ivan Radolović - Spacial Volunteer Support (SVS)


Top
 Profile  
Reply with quote  
PostPosted: October 15th, 2008, 1:08 pm 
Offline
SVS Member
SVS Member

Joined: May 5th, 2008, 4:53 pm
Posts: 304
This is what i need:
<!--LOOP(query,"SELECT * FROM songlist where songtype = 'S' ORDER BY date_played DESC limit 1")-->

Thanks to SAM support Team

_________________
Ivan Radolović - Spacial Volunteer Support (SVS)


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

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 7 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