PHP Loop MySQL results into array

Question

I have a table called people with the columns id (PK), fname, and lname.

It's simple enough to setup a loop out of the data:

$rs = mysql_query("SELECT * FROM people");
while($row=mysql_fetch_array($rs)){
    ...do stuff...
}

However, what I'm looking to do is loop the column/value pairs into an array automatically.

So, if I added a new column for email I can call the central function and just pull from $results['email'] while looping through the array.

What happens if you try to do that with your current code? Do you get an error? What is the error message? — Mark Byers
– Mark Byers, Commented Jul 5, 2012 at 18:53

Arnaud Le Blanc · Accepted Answer · 2012-07-05 18:49:42Z

2

Use mysql_fetch_assoc(), it returns an associated array with column names as values.

answered Jul 5, 2012 at 18:49

Arnaud Le Blanc

100k24 gold badges211 silver badges196 bronze badges

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

1 Comment

Fluidbyte Over a year ago

This works but only returns the first result. How would I get all of the results?

MDEV · Accepted Answer · 2012-07-05 19:06:00Z

1

$rs = mysql_query("SELECT * FROM people");
$results = array();
while(false !== ($row=mysql_fetch_assoc($rs))){
    $id = $row['id'];
    $results[$id] = $row;
}

$results is now a multi-dimensional array, each element being an array of fieldname => fieldvalue elements

Array
(
    [1] => Array
        (
            [id] => 1
            [fname] => John
            [lname] => Smith
        )
    [3] => Array
        (
            [id] => 3
            [fname] => Karen
            [lname] => Berry
        )
)

edited Jul 5, 2012 at 19:06

answered Jul 5, 2012 at 18:56

MDEV

10.9k2 gold badges35 silver badges50 bronze badges

Collectives™ on Stack Overflow

PHP Loop MySQL results into array

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related