Re: Help: do ... while, reverse data query

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