note 29717 added to function.mysql-data-seek

From: 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

« previous php.notes (#44358) next »