[RESOLVED] mysql_fetch_array() in function

patl

I would like to encapsulate mysql_fetch_array in a function that just returns an array containing the results. mysql_fetch_array seems to only return one row at a time though.

Is there a way to take the whole result set and put it directly in an array without sending mysql_fetch_array through a loop? Also, is there any downside to this? I just dont want to have to reuse mysql_fetch_array everytime i need data from a common query. Thanks a lot for any insight you can give me.

laserlight

Is there a way to take the whole result set and put it directly in an array without sending mysql_fetch_array through a loop?

No, but it is simple enough to use a loop to put the result set in an array.

bradgrafelman

patl wrote:
Is there a way to take the whole result set and put it directly in an array without sending mysql_fetch_array through a loop?

Not really, as said above.

patl wrote:
I just dont want to have to reuse mysql_fetch_array everytime i need data from a common query.

Why not? Any other PHP programmer on these forums who uses MySQL and wants to retrieve more than one row probably uses a loop in this manner.

It's simple, and it's what the function was made for. Why not?

function getData() {
   $return = array();
   $query = mysql_query("SELECT * FROM...");

   while($result = mysql_fetch_array($query))
       $return[] = $result;

return $return;
}

$AllRows = getData();

patl

cool. thanks for the help guys. In fact, i had gotten myself a little confused with mysql_fetch_array. I had forgotten that it does not actually touch the db, just the result set. Thanks a lot.

Second question if you have a chance:

I have a function that calls a number of other functions that each modify the database. If i would like that whole process to be one transaction, can i simply start the transaction at the beginning of the calling function, and then use 'commit' at the end after all the other functions modified the database? Thanks a lot for any insight.

bradgrafelman

If you have an InnoDB table, you can use the BEGIN/COMMIT statements.