how to fetch result set as an array

scorpioy

I use $result_set = mysql_query($query)
to get a set of rows, and then I can use mysql_fetch_array($result_set)
to access each value of column in a row, but each element inside is a column value of one row.

I want to get the result as an array from $result_set so that each element of array is an ENTIRE row, so I can add or remove elements inside. Is there such function?

Thanks.

leatherback

I don't think there is a function pre-build. But it is a matter of looping throuigh the results, and entering them into an array.

e.g.:

while($row=mysql_fetch_array($result_set))
{
$array[] = array(0=>$row[0]);
}

devinemke

what i typically do is create 2 dimensional arrays like so:

$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['id']] = $row;}

...where "id" is the name of the primary key field. you then have a 2D array with the primary keys field as the array keys and a sub-array of the individual row as the value.

leatherback

Of course..!
Much nicer.

Thx D., I'll store that for future ref 😉

yinrunning

devinemke wrote:
what i typically do is create 2 dimensional arrays like so:
$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['id']] = $row;}
...where "id" is the name of the primary key field. you then have a 2D array with the primary keys field as the array keys and a sub-array of the individual row as the value.

That's slick!