I was wondering about something. How can i sort the results of a mysql query.
This is what i have now :
<?
mysql_connect("somehost", "somone");
$query = "SELECT kamp_id, dag_dato, lag FROM kampoppsett";
$result = mysql_db_query("a_database", $query);
if ($result) {
echo "<b>Følgende kamper</b><ul>";
while ($r = mysql_fetch_array($result)) {
$kamp_id = $r["kamp_id"];
$lag = $r["lag"];
$dag_dato = $r["dag_dato"];
echo "<a href=vis_kamp.php3?kamp_id=$kamp_id>$dag_dato - $lag</a><br>";
}
echo "<ul>";
} else {
echo "Du har ikke laget noen sider enda. Klikk lag ny for og starte";
}
mysql_free_result ($result);
?>
How can i sort it in reverse order. The newest entry to the oldest? The page creates a link to a page that shows the entry in the database.
Fedde
Tought i never could do this......
