top artists – last month
now()
GROUP BY vote_artist
ORDER BY votes DESC, vote_timestamp DESC
LIMIT 10″;
$result_artist_month = mysql_query($query_artist_month) or die(mysql_error());
while ($row_artist_month = mysql_fetch_array( $result_artist_month )) {
if ($row_artist_month[‘count’] > 0) { ?> “;
}} ?>
top tracks – last month
now()
GROUP BY vote_artist, vote_track
ORDER BY votes DESC, vote_timestamp DESC
LIMIT 10″;
$result_track_month = mysql_query($query_track_month) or die(mysql_error());
while ($row_track_month = mysql_fetch_array( $result_track_month )) {
if ($row_track_month[‘count’] > 0) { ?>
top artists – all time
0) { ?> “;
}} ?>
top tracks – all time
0) { ?>
artists – negative vote
now()
GROUP BY vote_artist
ORDER BY votes ASC, vote_timestamp DESC) AS table_votes
WHERE votes < 0";
$result_artist_all = mysql_query($query_artist_all) or die(mysql_error());
while ($row_artist_all = mysql_fetch_array( $result_artist_all )) {
if ($row_artist_all['count'] > 0) { ?> “;
}} ?>