Help with SQL query and associative array

[indig0blue]

I am using a SQL query to pull data that I need for a report. I can get it to print out just fine on screen, but I can't figure out how to get the data into an associative array. I have been playing with this for the past few days and cannot get over the hump on this one.

Can someone please help?

The reason i need to get this data into an associative array is because the data represents a report I need to export into Excel via the xlsStream class.

Any help would be much appreciated. I need to get this done for my boss ASAP.

Thanks.

[Houdini]

$row = mysql_fetch_array($result, MYSQL_ASSOC);
Sorry here a link mysql_fetch_array()

[indig0blue]

Thank you for the help. I was able to get the results to go into an array but now I am only able to get one row of the array in the variable. I need the '$assoc' variable in the code below to hold every row so all the rows will show up in the excel file.

Here is the code i have for this:

$row=0;

while ($row=odbc_fetch_array($sql_result))
{
$ItemNum = $row['ItemNum'];
$Place = $row['Place'];
$QR = 1;
for ($i=0; $i<5; $i++)
{
$assoc = array(array("ItemNum" => $ItemNum, "Place" => $Place, "QR" => $QR));
//echo $assoc;
}
}

Thank you very much in advance.

[Houdini]

 $rowcount = 1;
while ($row = odbc_fetch_assoc($result)) {
            print "Row $rowcount<BR />";

        while(list($var, $val) = each($row)) {
            print "<B>$var</B>: $val<BR />";
        }

        print "<BR />";
        ++$rowcount;
    }