category visitor report query

[Anonymous]

Hi,

I have one table for category.

It has fields like category id (Primary key), category name, date_fld (09-12-2006).

I want to create a report like this:
On which date for which category how many visitors come?

Hows that possible?

http://mukeshvariya.blogspot.com

 

[Anonymous]

Just add a table to store page hits and than fetch reports as you wish. If you want some fast solution, just use phpMyVisit.

 

[gesf]

Try something like:

SELECT COUNT(hits_field), date_field FROM table GROUP BY category;