ballhogjoni Posted July 11, 2008 Share Posted July 11, 2008 In my query I want to order by the default_category, but this is not working. My default_category field is a tinyint, 1 being the default and 0 not the default. SELECT hotels_area_id, hotel_area FROM Hotels_Area ORDER BY default_category ASC, hotel_area ASC Link to comment https://forums.phpfreaks.com/topic/114314-solved-whats-wrong-with-my-mysql-statement/ Share on other sites More sharing options...
craygo Posted July 11, 2008 Share Posted July 11, 2008 query looks fine what is the problem with it?? Any errors?? Link to comment https://forums.phpfreaks.com/topic/114314-solved-whats-wrong-with-my-mysql-statement/#findComment-587830 Share on other sites More sharing options...
ballhogjoni Posted July 11, 2008 Author Share Posted July 11, 2008 No, its a smarty issue. I hate smarty sometimes. Thanks, anyway. Link to comment https://forums.phpfreaks.com/topic/114314-solved-whats-wrong-with-my-mysql-statement/#findComment-587834 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.