Posted by toedipper on 09/08/05 01:02

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.

• Next in forum: Analyzing dates in a table
• Prev in forum: Analyzing dates in a table
• Thread view: Analyzing dates in a table

[Reply to this message]