How to use order by in here

hi all,

I need to display all the countries and the current country should come first. How should i do this?

$sql = "SELECT * FROM $countries WHERE countryid = $country[countryid] AND enabled = '1' $sort2";

PHP:

thanks all

 

Hi,

What do you mean exactly you just want the current countryid at the top of the list and the rest of the ordering doesn't matter?
If so just use 2 queries display the current country in the first one and use the 2nd query to display the rest.

What is $sort2 out of interest?

 

thanks for your help. sorted.

ORDER BY countryname like '$xcountryname%' desc

PHP:

 

ORDER BY just refers to the table row value youre after the ordering by, 'desc' can be appended to change it to descending