Sorting problem

[Cokeman1974]

I can't find how I can sort the following query by categories_description.categories_name, think it has to do with the .$id at the end:

$query = "SELECT categories.categories_id, categories.parent_id, categories_description.categories_name FROM categories_description INNER JOIN categories ON (categories_description.categories_id = categories.categories_id)where categories_description.language_id = 4 and parent_id=".$id;

Any help?

Thanks

 

[vanekl]

to sort, just add:

... ." ORDER BY categories_description.categories_name"

 

[Cokeman1974]

Thanks, worked great.