PHP assign result from nested query into array
===

I need help in order to assign the results of a nested query into array. This is the scenario:

    $Date_Collection = mysql_query("SELECT DISTINCT Date FROM TblDate");
    
    while($date = mysql_fetch_array($Date_Collection)) // Loop through all the dates
    {
    	$var_date = $date['Date'];
    	$result = mysql_query("select min(Speed) as Min_spd, max (Speed) as Max_spd, avg   
                      (Speed) as Avg_spd from ... where Date= $var_date");
    
      while($row = mysql_fetch_array($result))
       {
         echo "row[Min_spd]";
         echo "row[Max_spd]";
         echo "row[Avg_spd]";
        }
     }

The output from this query is like this: 

Min_Spd |Max_Spd |Avg_Spd|  Date|

12.0|       25.0|       20.4|      2012-10-01|

11.0|       28.0|       21.4|      2012-10-02|

10.0|       26.0|       23.4|      2012-10-05|

08.0|       22.0|       21.4|      2012-10-08|

I basically need to show the sum of Min_Spd, Sum of Max_spd, Sum of Avg_spd for all these dates. So, I thought that If I can assign these values into an array and later compute these sum from the array, it might be a good idea.

Can anyone please help me regarding this? Can I use an array to store the values and later access these values and calculate the sum of these values. If I can use an array, could anyone please show me the syntax of using array in PHP. I would really appreciate any help regarding this.

Is there any alternative way rather than using an array, such as creating a temporary table to save these values and later delete the temporary table. If a temporary table can be used, could you please show me how to do that. I could use the temptable for a single loop, but there is a nested loop and I don't exactly know what to do to create a temp table inside the nested loop to store all the values.
