Array question

I want to insert into an array, $common["blah"], for each row in a table query. I want the key to be $row["settingname"] and the value to be $row["settingvalue"] Can you take a look at the following code and tell me how _you_ would have done it... Cheers! -------- $result = mysql_query("SELECT settingvalue FROM commonsettings",$connection); while ($row = mysql_fetch_array($result)) { $common[$row["settingname"]] = $row["settingvalue"]; }