Selecting relevant database entries.

[smithmr8]

Hi,

I want to be able to generate visitor statistics for a blog I'm creating. I'm going to be collecting numerous pieces of data when a post is viewed, including a time stamp of the visit.

 

I need to be able to select timestamps that were within the current day, the previous day, the day before that ect.. So that I can generate the statistics.

Show it for the current week (current day and 6 previous days).

 

So it would be the entries where the timestamp was made on the days: 11/1, 10/1, 9/1, 8/1, 7/1, 6/1, 5/1. For example.

 

Not quite sure how I could do this.

 

Thanks.

[johnny86]

I assume you're using MySQL, you could do something like:

 

SELECT all_you_need FROM table WHERE DATEDIFF(DATE(table.timestamp), DATE(NOW())) <= 6;

 

Would return you all the records from this date to six days back.

[smithmr8]

I need it for each day singularly, but can modify that. Much appreciated. Will give it a go.