getting MySQL results as PHP array

Question

mysql table:

+-------------------+----------------+
| config_name       |  config_value  |
+-------------------+----------------+
| allow_autologin   |       1        |
| allow_md5         |       0        |
+-------------------+----------------+

current php codes:

$sth = mysql_query("SELECT ...");
$rows = array();
while($r = mysql_fetch_assoc($sth)) {
    $rows[] = $r;
}
print_r($rows);

current result:

Array
(
    [0] => Array
        (
            [config_name] => allow_autologin
            [config_value] => 1
        )

    [1] => Array
        (
            [config_name] => allow_md5
            [config_value] => 0
        )

)

I want to get the result like that:

Array(allow_autologin => 1, allow_md5 => 0)

Answer 1

just add to your results like so:

$sth = mysql_query("SELECT ...");
$rows = array();
while($r = mysql_fetch_assoc($sth)) {
    $rows[$r['config_name']] = $r['config_value'];
}
print_r($rows);

Answer 2

while($r = mysql_fetch_assoc($sth)) {
    $rows[] = array($r['config_name'] => $r['config_value']);
}