Jaartallen

<?
$query = mysql_query("SELECT * FROM producten WHERE jaar='2004'");
echo "<b>2004</b><br>";
while($row = mysql_fetch_assoc($query))
{
echo $row['omschrijving']."<br>";
}
?>

<?
$query = mysql_query("SELECT * FROM producten WHERE jaar='2004'");
echo "<b>2004</b><br>";
while($row = mysql_fetch_assoc($query))
{
echo $row['omschrijving']."<br>";
}
?>

<?						
$selecteer = mysql_query("SELECT id, jaar FROM producten ORDER BY jaar DESC") or die(mysql_error());
while($obj = mysql_fetch_object($selecteer)){
echo"
<li><a href=\"index.php?page=product&jaar=$obj->jaar\">$obj->jaar</a></li>
";
}
?>

<?						
$selecteer = mysql_query("SELECT id, jaar FROM producten ORDER BY jaar DESC") or die(mysql_error());
while($obj = mysql_fetch_object($selecteer)){
echo"
<li><a href=\"index.php?page=product&jaar=$obj->jaar\">$obj->jaar</a></li>
";
}
?>

<?
$query = mysql_query("SELECT id, jaar FROM producten ORDER BY jaar GROUP BY jaar");
?>

<?
$query = mysql_query("SELECT id, jaar FROM producten ORDER BY jaar GROUP BY jaar");
?>