|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
03-15-2008, 12:37 AM
|
#1 |
|
Confirmed User
Join Date: Jun 2002
Location: My Coffin
Posts: 1,227
|
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 |
|
|
|
03-15-2008, 01:07 AM
|
#2 |
|
Confirmed User
Join Date: Sep 2006
Location: WA
Posts: 136
|
Uh...
select pagename, count(distinct surferIP) from pagevists group by pagename ?
__________________
Pimp pimp... hooray! Pimp pimp... hooray! |
|
|
|
|
03-15-2008, 01:21 AM
|
#3 | |
|
Confirmed User
Join Date: Jun 2002
Location: My Coffin
Posts: 1,227
|
Quote:
Hugs, Danielle |
|
|
|
|
|
03-15-2008, 01:26 AM
|
#4 | |
|
Confirmed User
Join Date: Jun 2002
Location: My Coffin
Posts: 1,227
|
Quote:
Hugs, Danielle |
|
|
|
|
|
03-15-2008, 02:26 AM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Jun 2003
Location: Vegas
Posts: 3,243
|
so.. you got it working correct?
|
|
|
|
