Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

SQL for Web Traffic Analysis Analysis

Dec 8, 2000, 10:54 PM
HiU
Novice (11 posts)
Dec 8, 2000, 10:54 PM
Post #1 of 2
Views: 2318
Shortcut
Quote Reply
SQL for Web Traffic Analysis Analysis
If I have a simple table which stores page viewed by every user with timestamp. like:

12345678901 page1name
98765432101 page2name
.......

I want to get reports:
hits by month,
hits by day,
hits by week-day,
hits by hour
...

Is it possible to use one query to get all?


Dec 9, 2000, 6:54 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Dec 9, 2000, 6:54 PM
Post #2 of 2
Views: 2253
Shortcut
Quote Reply
Re: SQL for Web Traffic Analysis Analysis In reply to
You could...using SUM and AVERAGE codes for the "hits" of pages.

Regards,

Eliot Lee