list table by date
| From: | Augusto Cesar Castoldi | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | list table by date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-48650@lists.php.net to get a copy of this message | ||
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