Re: [PHP] How to inverse the date sorting [IT WORKS! - THANKS!]

2001-02-15 Thread Malouin Design Graphique
Just as simple as that?! Thank you guys: Fang; Andrew and Joe. Much appreciated. Hope to be able to give a hand myself someday to newbies like me ;-) Won't have to ask this question again. Promessed! Mes salutations, Yves At 12:26 -0500 15/02/2001, Fang Li wrote: >add DESC after order by 'da

Re: [PHP] How to inverse the date sorting

2001-02-15 Thread Joe Sheble (Wizaerd)
add a DESC to your order by clause... fairly simple SQL syntax, could be picked up from a myriad of SQL references and manuals $sql = "select * from table_name WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 21 order by date DESC"; At 12:14 PM 2/15/01 -0500, Malouin Design Graphique wrote: >Hello, >