putting mysql results into 2 dimension array

[bizshop]

I'm having a problem with the syntax for putting mysql results into an 2 dimension array for a shopping page script.

The $products array is what I want (an array filled with arrays):

$products = array( array( "TIR", "Tires", 100 ),
array( "OIL", "Oil", 10 ),
array( "SPK", "Spark Plugs", 4 ) );

I can pull the info from the database:
while ($row = mysql_fetch_row($result)){
$ItemSKU=$row[0];
$ItemName=$row[1];
$ItemCost=$row[3];
$resultarray=array("$ItemSKU","$ItemName","$ItemCost");

But I'm banging my head against the wall trying to put those result arrays into the products array.

[drawmack]

The easy way

<?php
$products = array():  //add this line
while ($row = mysql_fetch_row($result)){
$ItemSKU=$row[0];
$ItemName=$row[1];
$ItemCost=$row[3];
$resultarray=array("$ItemSKU","$ItemName","$ItemCost");
$products[] = $resultarray; //and this line
?>

The memory saving way

<?php
$products = array():  //add this line
while ($row = mysql_fetch_row($result)){
    $products[] = $row;
?>

End transmition

[bizshop]

The memory saving one is so elegant it shines! Thanks...