Hi,

I have queried database and got 2 values ($city, $country) that I need.

Now, I want to make an array like that:

Code PHP:
$items = array(
"London"=>"Great Britain",
"Liverpool"=>"Great Britain",
"Madrid"=>"Spain",
"Barcelona"=>"Spain",
...);

My code:
Code PHP:
...
$sql="select country, city from $table group by city";
$items = array();
while($row=mysql_fetch_array($result)) {
		array_push($items, $city, $country);
}

How to do that?

Thanks.