#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2001
    Posts
    29
    Rep Power
    0

    Order by using two different values


    I am wondering how I would use the ORDER BY query, to order a set of results using two different fields.

    So it first of all order the cat_id in to number order. But as there will be serveral different rows with the same cat_id, I would then like to make it put in order by cat_order depending on the cat_id. So is this possible.
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    56
    Rep Power
    13
    ORDER BY cat_id, cat_order
    Casuistry Agnostic

IMN logo majestic logo threadwatch logo seochat tools logo