Option group select

[eluser]smilie[/eluser]
Hm, there would be probably an MySQL only solution for this, but only thing I can think of is:

Do 2 query's:
First query will get only unique countries.
Then, in second query build up array of all 'name' belonging to each country.

So, you will end up with array like this:

Code:

$select = array('england' => array('name1','name2','name3'), 'wales' => array('name1','name2'));

Then, you can simply do 2 foreaches to create select (HTML) as you want it.

Good luck