On 23-Jul-2001 Mike Mike wrote:
> Hi Folks,
> I'm trying to create a counter for my website. I'm
> trying to pull the last 7 days worth of data out of
> mysql. My sql statement is as follows.
>
> SELECT TheDate, Count(TheDate) AS CountOfdate
> FROM Counter
> WHERE (((TheDate)=Now()-7))
> GROUP
Of course, 0 records are ok. Here is an example of mine :
mysql> select now(), now()-7;
+-++
| now() | now()-7|
+-++
| 2001-07-23 21:45:53 | 20010723214546 |
+-++
1 r
Hi Folks,
I'm trying to create a counter for my website. I'm
trying to pull the last 7 days worth of data out of
mysql. My sql statement is as follows.
SELECT TheDate, Count(TheDate) AS CountOfdate
FROM Counter
WHERE (((TheDate)=Now()-7))
GROUP BY TheDate;
When I do this Sql Commmand it returns