Danielle

I have a table that has these fields

pagename
visitdate
surferIP

I can list raw page visits by doing this.

SELECT pagename, COUNT(*) FROM pagevisits WHERE visitdate >= '$search_date_start' AND visitdate <= '$search_date_end' GROUP BY pagename

What I want to do is list pages by UNIQUE visit.

How would I do that?

Hugs,
Danielle