ORDER BY question

[micmac]

Hi all,
If i have the following query:

$result = mysql_query("SELECT * FROM cat1,pref WHERE cat1.CatID = pref.CatID AND CatParent = $id AND active='yes' AND country IN('Global', 'UK') ORDER BY listing_position, CatName");

...how can i order my results so that they display the 'listing_position' on top followed by the 'pref' followed by the 'CatName'?
At the moment it is only displaying the 'listing_position', not the other results.
I might add that 'listing_position' is from another table.

Cheers,
micmac

[planetsim]

Well.. Im not actually sure. But go to the mysql docs and have a read on ORDER..

Its explained quite well and i think it could be possible.. Also with vars in your select statement put ' around them.