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?