Query output

[Anon]

Hello,

I have a table like this:

date | hits | sales

2002-03-01 | 1 |0
2002-03-04 | 5 |1
2002-03-11 | 4 |0

Every time a new hit or sale is made on a new date a new row is added to my table. So far everything works.

Now I would like to output a overview from a period from 2002-03-01 to 2002-03-11.
My query find 3 rows, but in my overview I would like to see all dates between 2002-03-01 to 2002-03-11, something like below:

<table bla bla>
2002-03-01 | 1 | 0
2002-03-02 | 0 | 0
2002-03-03 | 0 | 0

etc.

</table bla bla>

How do I make a loop that can do that?
Or maybe a mysql query?

Thanks,
Michael

[van__]

$stmt = "SELECT * FROM myTable WHERE (UNIX_TIMESTAMP(dateColumnName) > UNIX_TIMESTAMP($date1)) AND (UNIX_TIMESTAMP(dateColumnName) < UNIX_TIMESTAMP($date2)) ORDER BY UNIX_TIMESTAMP(dateColumnName)";

[Anon]

This is not exactly what I'm looking for...

I need a loop that can fill out the dates that are not in the table.

[Anon]

You'll have to use 2 loops, one inside the other. The first outside loop will loop thru the query results. The loop inside will display all the dates in between. You can build timestamps to compare the dates.

HTH,

Diego