You can sort in descending order in your sql statement
select * from messagem where flag-1 order by date desc
Seung-woo Nam
Augusto Cesar Castoldi wrote:
>
> 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]
