Re: [PHP-DB] Help: do ... while, reverse data query

2003-11-05 Thread CPT John W. Holmes
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 *

Re: [PHP-DB] Help: do ... while, reverse data query

2003-11-05 Thread Boyan Nedkov
you can do it at sql level by using ORDER BY ... DESC like: SELECT * FROM categories WHERE cat_id = '$cat' ORDER BY cat_id DESC and then proceed the returned recordset in 'normal' way (order) -- Douglas Freake wrote: Hi there, I need to do a loop where the mysql query starts at the bottom and