Prøv lige det her:
<?php
$connection = mysql_connect(\"localhost\",
\"xxxxxx\",
\"xxxxxx\");
mysql_select_db(\"xxxxxx\", $connection);
$result = mysql_query(\"SELECT nick,date_format(tid, \'%e/%c %Y, %H:%i\') as time,data FROM news ORDER BY tid DESC\");
while ($row = mysql_fetch_array($result)) {
echo \"<table width=\\\"50%\\\" border=\\\"1\\\" height=\\\"50\\\" bordercolor=\\\"#FFFFFF\\\">\";
echo \"<tr><th height=\\\"20\\\" bgcolor=\\\"AF6480\\\"><div align=\\\"left\\\"><b><font face=\\\"Garamond\\\" size=\\\"3\\\" color=\\\"#FFFFFF\\\">$row[nick] $row[time]</font></b></div></th></tr>
<tr><td height=\\\"30\\\"><div align=\\\"left\\\"><b><font face=\\\"Garamond\\\" size=\\\"3\\\" color=\\\"#FFFFFF\\\">$row[data]</font></b></div></td></tr></table><br><br>\";
}
?>
</table>
MySQL kan i hvert fald finde ud af at sortere et datetime!
Måske virker det...
Jens Gram -
www.jensgram.dk