[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

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