21 April:
track 10
track 09
track 08
20 April:
track 07
track 06
19 April
track 05
track 04
track 03
track 04
enz :)
Mijn code:
<?php
//
// TRACKS VAN DE LAATSTE DAGEN OPHALEN
//
$query = "SELECT DISTINCT DATE(track_date) as track_date FROM track ORDER BY track_date DESC";
$result = mysql_query($query) or die ( mysql_error( ) );
while($rs = mysql_fetch_assoc($result))
{
echo "<br /><h3>" . $rs['track_date'] . "</h3>";
// TRACKS OPHALEN PER DATUM
$query = "SELECT * FROM track WHERE track_date = '" . $rs['track_date'] . "' ORDER BY track_date DESC";
$result1 = mysql_query($query) or die(mysql_error());
while($rs1 = mysql_fetch_assoc($result1))
{
echo $rs1['track_artiest'] . " - " . $rs1['track_artiest'] ." (". $rs1['track_rmx'] ."<br />";
}
}
?>
Ik krijg nu dus allen de verschillende datums te zien, en niet de tracks.
Iemand een idee?