[RESOLVED] Storing MySQL results to a multidimensional array

[jooky2000]

I need to store results from a MySQL call to a multidimensional array. My code is as follows:

$db = mysql_connect("localhost", "admin", "password");
mysql_select_db("myDatabase",$db);
$query = "SELECT * FROM content WHERE filetype LIKE 'URL'";
$result = mysql_query($query);

for($i=0;$row = mysql_fetch_array($result);$i++){
    $multiResults[$i] = array(mysql_fetch_row($row));
} 

I assume that since the result of $row is an array that assigning it to the first element of another array would do the trick, but when I look at the results, I get nothing.

Thanks in advance.

[jooky2000]

Okay a little digging later and I figure it out.

    $db = mysql_connect("localhost", "username", "password");
    mysql_select_db($dbName, $db);
    // here's the query
    $result = mysql_query("SELECT * FROM $tableName ");
    // here's how we store the results in an array 
    $rs = array();
    while ($row = mysql_fetch_row($result))
    {
        array_push($rs, $row);
    }
    return $rs;

Theoretically seems the same, yet isn't but solved the problem. This function returns results to a Flash Front End.

Cheers!