note 29717 added to function.mysql-data-seek
| From: | John at rack1 dot php dot net | Date: | Sat, 22 Feb 2003 23:30:43 +0000 |
| Subject: | note 29717 added to function.mysql-data-seek | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-44358@lists.php.net to get a copy of this message | ||
$query = "SELECT headline, date FROM
news ORDER BY date DESC LIMIT 5
";
$result = mysql_query($query)
or die("Query failed: " . mysql_error());
/* fetch rows in reverse order */
for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i: " . mysql_error() . "\n";
continue;
}
That puts the rows i want in reverse order, how do i put them in the right order like
row8 first and
thwn row 7 ans so on
plz help me
--
http://www.php.net/manual/en/function.mysql-data-seek.php
http://master.php.net/manage/user-notes.php?action=edit+29717
http://master.php.net/manage/user-notes.php?action=delete+29717
http://master.php.net/manage/user-notes.php?action=reject+29717