在php中优先打印数组值

Question

I have country table,

i fetch all values and moved into array ,

these value i like to populate into combo/dropdown list ,

here i want to do some magic things,

that is , for my site most of the users coming from uk,us,Australia,Romain and few,

So i like to populate by my preference ,

is there any array will do this magic work, else is it possible mysql query ,

So final question is ,

Populate country name into combo based on my prefernce ,

Thanks

Answer 1

It's very annoying to have a country list where not all items can be found at their alphabetical position. I suggest you just duplicate the top 2 or 3 more used items and show them at the top of the complete list:

Australia
United Kingdom
United States
---------------
Afghanistan
Albania
Australia
Austria
...

I'm not sure, though, why you think this involves any sort of magic. You could accomplish this by adding a new weight column to the country table in your database that defaults to e.g. 1 and increment it to larger values for items you want to highlight. You can then build your data in PHP or in SQL.

SELECT country_id, country_name
FROM country
WHERE weight>1
ORDER BY weight, country_name
UNION ALL
SELECT country_id, country_name
FROM country
ORDER BY country_name