How to inverse the date sorting
| From: | Malouin Design Graphique | Date: | Thu, 15 Feb 2001 17:14:59 +0000 |
| Subject: | How to inverse the date sorting | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-39948@lists.php.net to get a copy of this message | ||
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...
---------------------------------------------
<?php
$db = mysql_connect("servername.com", "root", "password");
mysql_select_db("stats", $db);
$sql = "select * from table_name WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 21 order by 'date'";
$result = mysql_query( $sql );
while ( $row = mysql_fetch_array( $result ) )
{
echo "<tr><td><span class=\"size1\"><b>$row[date]</b><br><img src=\"$row[indice_url]\"><br>$row[indice]<hr noshade size=\"1\"></span></td></tr>\n";
}
?>
---------------------------------------------
Thanks again for your help.
Merci beaucoup,
Yves
--
------------------------
Malouin Design Graphique
http://www.malouin.qc.ca
Québec (Québec) CANADA