[PHP] list table by date

[Augusto Cesar Castoldi]

I have a little mysql question. I'm using php to list  a table from mysql.

I'm doing: $result=mysql_query("select * from messagem where flag=1 order
by
date");

But The first list of the "mysql_fetch_row($result)" is the first date. I
want to start printing by the last date.

But I want to know if I can do this by the mysql_query. I don't want this:

$i = mysql_numrows($result);
while ($i >= 0) {
  print mysql_result($result, $i, 'date')."<br>";
}

regards,

Augusto Cesar Castoldi




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]