Database info as multidimensional array?

Pragz

Is it possible to have info from a database be pulled into a useable multidimensional array? Where variables from it would be called as $tablename['rowname']['fieldname']?

So if I had a table called random and it was set up like this:

the variable $random['user_1']['prenom'] would return joseph. Get what I'm going for?

bradgrafelman

You could certainly build an array like that... just loop through the result set and store the row in a multi-dimensional array, e.g.:

$users = array();

while($row = mysql_fetch_assoc($result)) {
    $users[$row['username']] = $row; // duplicates the 'username' field

// if you don't want to do this, then try something like:
$user = $row['username'];
unset($row['username']);
$users[$user] = $row;
}