ORDER BY or SORT

[adman4054]

Hi --

 

I cant figure out how to sort/order this query. I'd like to display the category alphabetically.

"SELECT category.* FROM categorylisting LEFT JOIN category ON categorylisting.categoryid = category.categoryID WHERE categorylisting.listingid = '$listID' AND category.parentID = '86608'";  

Thank you

[Barand]

add

ORDER BY category

to the end of your current query

 

 

see http://dev.mysql.com/doc/refman/5.6/en/select.html

Edited June 9, 2013 by Barand

[adman4054]

thanks!