[SOLVED] country listing

[anujgarg]

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??

[sasa]

... ORDER BY FIELD(id, 38, 223, 222) DESC

[anujgarg]

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?

[sasa]

... ORDER BY FIELD(id, 38, 223, 222) DESC, name

[anujgarg]

nice....thanx sasa