Re: [PHP] list table by date

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 w

[PHP] list table by date

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