Analyzing dates in a table

Hello,

PHP and MySql

Thanks to everyone for help on questions I've posted here. Here's
another....

Imagine I have a table containing details of pageviews on a website. To
keep the example simple this table has a colum called 'Date' and imagine
that the earliest date in there is 01/01/04 (01 Jan 04) and each
individual page view has a row.

Can anyone point me in the direction how I could report on this data so
that for example I could display on screen -

Views Today
Views This Week
Views This Year
Views Last Year etc etc

Thanks,

rg.
Received on Tue Oct 18 02:20:03 2005