group by or order by problem

[mre2mpo]

I have a query where I want to search for users from a county but there is also a nearestcity field. What I want to do is select a nearestcity and display these first and then display the rest of the users from that county.

 

I am not quite sure how do it.

 

$query = \"select * from users where county = $countyname ?????then wat do I need to do with $countyname.

 

Michael

[mre2mpo]

sorry the last bit should not be $countyname but $cityname

[mre2mpo]

I have fixed the problem if anyone else has the same problem then the code is

 

$query = \"select * from user where county = $countyid order by nearestcity = $nearestcityid DESC;