Help with arrays and mysql datasets

Hi

I'm trying to step through a mysql query dataset and match each row to dates in an array, and if they match, make basic calculations and assign the values back to an array.

So, I have $rangearray[] that contains my date selection in "YYY-MM-DD" format stepping in one day steps.

I do my query within the same date range.

So, my query resultset can contain any number of rows for each given date in the date range - iow, there can be more than one row in the resultset for "2008-09-09" for instance, and then none for "2008-09-08" for instance.

So the "logic" behind what I'm trying to do is like this:

Step through the $date_range array with a foreach, and for each date value, check to see:
a) how many rows in the query resultset matches this date
b) add up all the values of a speciffic collumn in the resultset
c) assign these two values to two arrays ( or "0" if no rows match)

So that after the stepping through is completed, I will have two new arrays with the same count as the original $date_range array.

My problem is I don't know what the most efficient way is to do this: a foreach with the while loop stepping through the mysql results nested inside, or first running through the while loop of the query results and then creating an array of that and THEN compare the two arrays with each other?

Any help appreaciated.  Start Free Trial