Return mySQL query in array??

m3avrck

Hi.

I'm trying to return the result of mySQL query in an associate array. I know if I do:

while ($row= mysql_fetch_assoc($result)) {
  foreach ($row as $key=>$value) {
    echo "Key:$key Value:$value<br>";
    $array[$key]= $value;
  }
}

I can put those values in array (note the problem with $keys having more than 1 $value).

However, is there already a PHP function to do this? I can't seem to find anything like this out there. And using mysql_fetch_assoc only gets one row at a time. I want them all at the same time.

Thanks.

cdbsi

while ($row= mysql_fetch_array($result)) {
printf("Key:%s Value:%s<br>", $row["key"], $row["value"]);
}

m3avrck

Thanks.

michael

$result=mysql_query($dbi, 'select * from mytable where id > 50 limit 50');

while (NULL!=($myentry = mysql_fetch_array($result, MYSQL_ASSOC)) {

foreach($myentry as $column=>$coldata) {
print "$column = '$coldata'";
}
}

Something like that.
Nothing is warrantied.

m3avrck

Instead of:

($myentry = mysql_fetch_array($result, MYSQL_ASSOC))

Try:

($myentry = mysql_fetch_assoc($result))

Does the same thing but cleaner code. Supposedly it handles NULL too, not sure, haven't tried it out.

michael

OH!

I didn't read your question all the way.
+=)

I do it my way, thank you.

To answer your question, no there is not a predefined function.

The code you want would be like:

$result = mysql_query($dbi, $query);

while ($row= mysql_fetch_assoc($result)) {
$mydata[]= $row;
}

This will give you all the rows in an multidimesional(sp) array.