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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
