Array or result handler?

[waimichael]

I'm working with the application which uses PHP and MySQL. One question of me is that after I connected to the database and submitted the query, I got the result handler back. Is it better to transfer all the content of the result from the query into an array? Or just use the result handler to do what I want? Please comment on it. Thanks everybody.

[mcgruff]

Definitely use the result resource. Unless you have some kind of obscure need for an array, there's no point in using up memory to duplicate the resource in array form.

If you've got a single row in the resource $query:

$result = mysql_fetch_array($query);

.. and get each bit of data with: $result['keyname']

Multiple rows in $query:

while ($result = mysql_fetch_array($query)) {

echo $result['keyname1'];
echo $result['keyname2'];
.. etc

}

.. just echo'ing here: do whatever you have to do.

print_r($result); is handy for debugging

[waimichael]

Oh yes ... you make it clearly to understand ... thx ~