GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Any mySQL experts around? (https://gfy.com/showthread.php?t=815228)

Danielle

03-15-2008 12:37 AM

Any mySQL experts around?

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

hand-held

03-15-2008 01:07 AM

Uh...

select pagename, count(distinct surferIP) from pagevists group by pagename

?

Danielle

03-15-2008 01:21 AM

Quote:

Originally Posted by hand-held (Post 13923505)

Uh...

select pagename, count(distinct surferIP) from pagevists group by pagename

?

Actually tried that. It returned zero for each pagename.

Hugs,
Danielle

Danielle

03-15-2008 01:26 AM

Quote:

Originally Posted by hand-held (Post 13923505)

Uh...

select pagename, count(distinct surferIP) from pagevists group by pagename

?

Hold on. You are right! Thanks! I was trying to display it wrong.

Hugs,
Danielle

Catalyst

03-15-2008 02:26 AM

so.. you got it working correct?

All times are GMT -7. The time now is 06:42 AM.