fetch the ENTIRE array?

[CloudedVision]

mysql_fetch_array() returns one row of the results. Is there a way to put ALL the results into a single array? I could do a while loop with mysql_fetch_array to build an array, but that would take up more CPU cycles than I would like.

[Rob]

Recordsets cannot be returned in a single command to my knowledge.

Looping is a standard practice - even on webforumz.

If there was a PHP command (which there may well be) there will STILL be a loop happening except you wont see it, and if the loop didnt happen in PHP, then it would happen on the database.

[Weird1993]

I've never heard of such a function or such to do this, but as Rob pointed out, it would still run a loop in the background if such was possible.

[kerrsmith]

Here is a basic example of how you do the MySQL loop:

$result = mysql_query("SELECT username FROM accounts");
while($row = mysql_fetch_array($result))
{
print $row[username];
}

This will print out all the usernames from table accounts in your database.