About creating an array at php.

[manolis]

Hi,

I am having trouble at creating a specific array.
What i want is to pull the info for my members (from mysql database) and then store them to an array.
The array should be like this:

$members = array(
'John' => array('avatar' => '/images/avatar/ji.jpg', 'country' => 'uk.'),
'Nick' => array('avatar' => '/images/avatar/nick.jpg', 'country' => 'italy.'),
);

etc..
so i pull the name,avatar url and country from the db and then i store them in to the previous array.
My question is, how could i create this array?

Thanks in advance!

[Niheel]

You query the database and then run a while loop on the results. Then dump the row information into an array called users.

Below's an example.

$result = mysql_query("SELECT name,avatar,url,country FROM mytable");

$users = array();
while ($row = mysql_fetch_array($result)) {
    $users[$row["name"]] = $row; 
}