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...
-
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,
by 'date', it will be
$sql = "select * from table_name WHERE TO_DAYS(NOW()) - TO_DAYS(date)
= 21 order by 'date' DESC";
Fang
-Original Message-
From: Malouin Design Graphique [mailto:[EMAIL PROTECTED]]
Sent: February 15, 2001 12:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP] How to invers
3 matches
Mail list logo