Help: do ... while, reverse data query
| From: | Douglas Freake | Date: | Wed, 05 Nov 2003 17:34:58 +0000 |
| Subject: | Help: do ... while, reverse data query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31441@lists.php.net to get a copy of this message | ||
Hi there,
I need to do a loop where the mysql query starts
at the bottom and goes up, as if the data was in
reverse order. This is for building a category/
sub_category menu.
Data structure: (cat_id, cat_sub, cat_name)
sample routine:
do {
$sql = "SELECT * FROM categories WHERE cat_id = '$cat'";
$go = mysql_num_rows($sql_result);
$cat = $row["cat_sub"];
$cat_id = $row["cat_id"];
} while ( $go == 1);
Any ideas how to to start a the end of the database?
Thanks for your help!
Doug