adman4054 Posted June 9, 2013 Share Posted June 9, 2013 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 Link to comment https://forums.phpfreaks.com/topic/278967-order-by-or-sort/ Share on other sites More sharing options...
Barand Posted June 9, 2013 Share Posted June 9, 2013 add ORDER BY category to the end of your current query see http://dev.mysql.com/doc/refman/5.6/en/select.html Link to comment https://forums.phpfreaks.com/topic/278967-order-by-or-sort/#findComment-1435009 Share on other sites More sharing options...
adman4054 Posted June 9, 2013 Author Share Posted June 9, 2013 thanks! Link to comment https://forums.phpfreaks.com/topic/278967-order-by-or-sort/#findComment-1435027 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.