Create array from MySQL results

[Anon]

I'm sure somewhere here there's an answer to this, and I'm sorry I'm posting this, but I can't really find it.
I have a MySQL call that returns 1 record for an n number or rows. I need to create an array like this array(recordofrow1, recordofrow2, etc. etc.), so that results are not one per row (each row being an array) but one per array position. Is there a while function I can use to do this? Thanks very much in advance for any help.

[eduard]

May I ask a annoying question too???

$Query = "Select * from tblName";
$res = mysql_query($Query, $connectString);

Isn't '$res' here already an array???

[Anon]

No $res is NOT an array, $res is a result index.

this is the way, Abe:

$query = "SELECT t1.* FROM table t1";
$result = mysql_query ( $query );

$results = array ();
$a = 0;
while ( $row = mysql_fetch_array () )
$results [ $a++ ] = $row;
// or in php4:
while ( $results [] = mysql_fetch_array () )
;

Next time, check the manual, it's all there.

[Anon]

Thanks drm for your help. Of course I checked with the manual first, I must have missed this, sorry.