-
Help with a query
I have a table that logs visitors to my websites.
it has the follwoing fields (plus others not important):
Host - the website
path - page accessed
IP - of the visitor
date
time
what i'm trying to do is get the entry points to my websites.
I will treat the first time a visitor (actual time) accesses the page on a particular day as the entry point.
out put should be:
HOST - PATH - NO OF ENTRIES (count path)
How would i go about this?
i can count the host for each path no problem, but how can i get this info for only the first I.P access for each day?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|