Help with date query!
Posted 30 June 2006 - 04:46 PM
select tbl_voter.songid, tbl_artists.artistName, tbl_songs.songTitle, tbl_songs.songUrl, tbl_labels.labelName, tbl_voter.voteDate, count(*) AS Votes from tbl_voter, tbl_songs, tbl_artists, tbl_labels WHERE tbl_songs.artistID = tbl_artists.artistID AND tbl_songs.songID = tbl_voter.songID AND tbl_artists.labelID = tbl_labels.labelID AND tbl_voter.voteDate >= '2006-05-28' group by songid order by Votes DESC;
Any advice appreciated!
Posted 30 June 2006 - 06:18 PM
Posted 03 July 2006 - 05:09 AM
Posted 05 July 2006 - 05:31 AM
Background info: I want a script that will pull out 10 songs with the most votes from dB. I want the voteDate to be a variable in the query so I can change it with PHP. I was just testing it with a date to see if it would work.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users