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

2001-02-15 Thread Malouin Design Graphique
uary 15, 2001 12:15 PM >To: [EMAIL PROTECTED] >Subject: [PHP] How to inverse the date sorting > > >Hello, > >Anybody here would know, how I could inverse the date sorting or ordering? > >This script below gives me for example: >2001-01-01 >2001-01-15 >2

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, >

[PHP] How to inverse the date sorting

2001-02-15 Thread Malouin Design Graphique
Hello, Anybody here would know, how I could inverse the date sorting or ordering? This script below gives me for example: 2001-01-01 2001-01-15 2001-01-31 and so on... when I wish it would gives me: 2001-01-31 2001-01-15 2001-01-01 and so on... - $ro