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

Reply via email to