Danielle

I have this mySQL query that displays raw page visits.

SELECT DISTINCT page_visited, COUNT(page_visited) FROM clubd_counter_data GROUP BY page_visited ORDER BY page_visited

The table has a field called surfer_ip that holds the ip of the surfer that visited a page.

Now what I want to do is display unique ip vists per page. What do I need to add to the above SQL query to get that? I want the count to be unique page visits instead of all page visits.

Hugs,
Danielle