| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|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 ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved