From: "Douglas Freake" <[EMAIL PROTECTED]>
> 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?
Yes, it's called an ORDER BY clause.
SELECT * FROM categories WHERE cat_id = '$cat' ORDER BY cat_id DESC
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
