creating an array from database data

I am trying to run a mysql_query and return all the results which match the criteria, and then create an array with that data. Any ideas of the best way to do this?

I was using mysql_fetch_assoc(); but then I realized that this function only returns a single result at a time. Are there any functions that will return all the results into an array? Or another way to solve my problem?

Thanks!

Smesh

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

print_r($array);

Thanks!

Works perfectly :)

Smesh

Use mysql_fetch_array($result)?