Re: 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 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 >