| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, subscribe, help, library, 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.
© Webmaster World 1996-2014 all rights reserved