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)

Matt Ellen · Accepted Answer · 2011-09-18 15:43:26Z

6

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);

answered Sep 18, 2011 at 15:43

Matt Ellen

11.6k5 gold badges73 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bee gees Over a year ago

yes. it works. thank you very much. perfect help. A+. thanks. i gotta wait 7 minutes to select your answer..

jasonbar · Accepted Answer · 2011-09-18 15:41:15Z

4

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

answered Sep 18, 2011 at 15:41

jasonbar

13.5k4 gold badges41 silver badges47 bronze badges

Comments

Dan · Accepted Answer · 2011-09-18 15:42:57Z

1

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

answered Sep 18, 2011 at 15:42

Dan

5,6978 gold badges50 silver badges75 bronze badges

Collectives™ on Stack Overflow

getting MySQL results as PHP array

3 Answers 3

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Linked

Related