anujgarg Posted August 28, 2008 Share Posted August 28, 2008 Hi I have a database with country id and country name. The country id is in auto increment order. I want to show country names with US, UK and Canada on the top of my drop down list. In my database, the IDs for US, UK and Canada comes under 222, 223 and 38 respectively. How can I bring these names in the top 3 position in my drop down. I tried with IN('222', '223', '38') and NOT IN('222', '223', '38') clauses, but it did not work. Any suggestions?? Quote Link to comment https://forums.phpfreaks.com/topic/121665-solved-country-listing/ Share on other sites More sharing options...
sasa Posted August 28, 2008 Share Posted August 28, 2008 ... ORDER BY FIELD(id, 38, 223, 222) DESC Quote Link to comment https://forums.phpfreaks.com/topic/121665-solved-country-listing/#findComment-627652 Share on other sites More sharing options...
anujgarg Posted August 28, 2008 Author Share Posted August 28, 2008 Thanx sasa, it worked. But here, rest of the country names order also gets disturbed. how can I save the alphabetic order for the rest of the countries? Also, I need a separator (say ---------), after these 3 country names. How can I insert it? Quote Link to comment https://forums.phpfreaks.com/topic/121665-solved-country-listing/#findComment-627682 Share on other sites More sharing options...
sasa Posted August 28, 2008 Share Posted August 28, 2008 ... ORDER BY FIELD(id, 38, 223, 222) DESC, name Quote Link to comment https://forums.phpfreaks.com/topic/121665-solved-country-listing/#findComment-627703 Share on other sites More sharing options...
anujgarg Posted August 28, 2008 Author Share Posted August 28, 2008 nice....thanx sasa Quote Link to comment https://forums.phpfreaks.com/topic/121665-solved-country-listing/#findComment-627721 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.