PHP Mysql Select all of 1 Column, name variables with another column

[lemonshindig]

I know how to use php's mysql functions to retrive 1 row of coding, but how would I go about making an array with the array's variable names coming from one column, and the array's variable values coming from another, correspondingly?

Thanks!

[lemonshindig]

Well... I think I figured out the solution to my problem.

while ($currentrow=mysql_fetch_array($result)) {
$flags[$currentrow['country']] = $currentrow['flag'];
}


I think that will work... but i haven't been able to test it yet, because i'm having trouble logging into the database.

Thanks