Gwaihirjp Posted January 10, 2009 Share Posted January 10, 2009 Hi, I have a table in the database full of information of cars, and when I extract the info via PHP I want it ordered by company name but not exactly in alphebetical order. I need the company "TOYOTA" to be on top, and then all the other companies (Nissan, Honda, Chevrolet, etc) to come after it in alphabetical order. Only "TOYOTA" has to be prioritized and at the top. I know, it's a strange way to order soemthing, but is it possible? I looked up on how to use "order by field", but I'm not sure if that's the way to accomplish it. Is there an easier way to do it? Quote Link to comment https://forums.phpfreaks.com/topic/140264-solved-customizing-order-of-results/ Share on other sites More sharing options...
dreamwest Posted January 10, 2009 Share Posted January 10, 2009 Easier to make 2 separate requests, and store them in different variables Quote Link to comment https://forums.phpfreaks.com/topic/140264-solved-customizing-order-of-results/#findComment-733959 Share on other sites More sharing options...
fenway Posted January 11, 2009 Share Posted January 11, 2009 Easier to make 2 separate requests, and store them in different variables Not at all. Use "ORDER BY ( yourField = 'TOYOTA' ) DESC, yourField ASC" Quote Link to comment https://forums.phpfreaks.com/topic/140264-solved-customizing-order-of-results/#findComment-734570 Share on other sites More sharing options...
Gwaihirjp Posted January 12, 2009 Author Share Posted January 12, 2009 Easier to make 2 separate requests, and store them in different variables Not at all. Use "ORDER BY ( yourField = 'TOYOTA' ) DESC, yourField ASC" Wow, this worked like magic!! I didn't know there was a way to order it like that. Thank you so much! Quote Link to comment https://forums.phpfreaks.com/topic/140264-solved-customizing-order-of-results/#findComment-735200 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.