Welcome to WebmasterWorld Guest from 54.159.50.111

Forum Moderators: open

Message Too Old, No Replies

Group by highest number count

group by highest number count

     
12:30 am on May 27, 2010 (gmt 0)

Junior Member

5+ Year Member

joined:July 24, 2009
posts: 113
votes: 0



hi,

i can retrieved all data count number group by specific column but the list are huge and i would like to retrieve and show only the group highest count number > 0. i tried to add ' FROM uniquelog where by useragent > 0' but the result were all nil. Could someone shows me the right path
Thanks



$data = mysql_query("SELECT DISTINCT useragent, round(count(useragent)/$num_rows * 100,2) as numscene FROM uniquelog WHERE useragent IS NOT NULL AND useragent!= '' GROUP By useragent")
or die(mysql_error());
2:50 am on May 27, 2010 (gmt 0)

Junior Member

5+ Year Member

joined:July 24, 2009
posts:113
votes: 0


nevermind i have figure out by applying 'HAVING Total > 3' at the end of Group By and it worked pretty well now. Thx
9:49 pm on June 1, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Dec 9, 2003
posts:3416
votes: 0


Glad you got it sorted out chrissim. :)