Array from Database PHP

Question

Hi I need to create an array from database; myTable looks like this

id           | name       | address |
-------------+------------+---------------
1            | Peter      | Union Streeet|
2            | John       | King Street  |

Then I have sql that will select values from database

$record=mysql_query("SELECT * FROM myTable");
while($row=mysql_fetch_assoc($record)){
      //fill array how to fill array that will look like bellow from database???
}

I need to create array that will look like this

$list = array (
    array('$row[id]', '$row[name]', '$row[address]'),
    // array('$row[id]', '$row[name]', '$row[address]')
    // FOR EACH LINE FROM DATABASE NEW NESTED ARRAY
);

peter.svintsitskiy · Accepted Answer · 2013-02-27 13:22:48Z

6

$record=mysql_query("SELECT * FROM myTable");
$list = array();
while($row=mysql_fetch_assoc($record)){
      //fill array how to fill array that will look like bellow from database???
    $list[] = row;
}

answered Feb 27, 2013 at 13:22

peter.svintsitskiy

3221 silver badge9 bronze badges

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

1 Comment

Mike Over a year ago

$list[] = $row;

Prasanth Bendra · Accepted Answer · 2013-02-27 13:23:32Z

3

Try this :

while($row=mysql_fetch_assoc($record)){
     $list[] = $row;
}

echo "<pre>";
print_r($list);

answered Feb 27, 2013 at 13:23

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

Collectives™ on Stack Overflow

Array from Database PHP

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related