majocmatt Posted March 15, 2007 Share Posted March 15, 2007 I have a list of country names in a database that is constantly being updated - countries are being added and deleted. It's for a client, and this is the way it has to be. My problem is getting USA to always be on top of the select dropdown list I populate on the admin page. Is this possible in a query? Can I ORDER BY countries in aplha order then force USA to be on top? I cannot order them by ID because, like I said, countries are coming and going, and it would screw up the order. I just need to know if it's possible in the query to do this? Thanks, Matt Link to comment https://forums.phpfreaks.com/topic/42880-order-by-question/ Share on other sites More sharing options...
effigy Posted March 15, 2007 Share Posted March 15, 2007 ...ORDER BY IF(country='USA', 0, 1), country Link to comment https://forums.phpfreaks.com/topic/42880-order-by-question/#findComment-208274 Share on other sites More sharing options...
fenway Posted March 15, 2007 Share Posted March 15, 2007 You can use order by field() as well... Link to comment https://forums.phpfreaks.com/topic/42880-order-by-question/#findComment-208400 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.