| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Count multiple secondary children values as one|
| 1:24 pm on Jan 28, 2011 (gmt 0)|
I have this db:
id domain page clicks
1 domain1.com /about_us 11
2 domain1.com /contact 22
3 domain2.com /about_us 33
3 domain2.com /some_page 44
Is it possible to do an automated query, without any PHP usage, to count all page clicks, but refer it to as the parent domain name?
The output that I'm trying to achieve:
| 5:58 pm on Jan 28, 2011 (gmt 0)|
SELECT domain, SUM(clicks) AS totalClicks FROM table GROUP BY domain
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved