Issue Retrieving Array From MySQL Database

[Dan_Mason]

Hello

 

I am having trouble retrieving an array in the format I need from a mysql database.

 

It is a Matrix/Multidimensional Array, and should look like this:

 

Array( Array(Date => 22/04/1989, Time =>02:00) Array(Date => 23/04/19...... etc

 

For some reason it is coming back like this:

 

Array( Array( Array(22/04/1989), Array(02:00) ) Array( Array(23/04/19...... etc

 

This is the code that puts the mysql result in the array:

<?php

      while ($aTemp[] = mysql_fetch_array($result, MYSQL_NUM));

?>

 

 

Any suggestions would be very useful!

 

Thanks!

 

Dan

 

[ChemicalBliss]

      while ($row = mysql_fetch_array($result, MYSQL_NUM)){
            $aTemp[]['Date'] = $row[0];
            $aTemp[]['Time'] = $row[1];
      }

 

Hope this helps,

-cb-