TalkPHP - View Single Post - How to get row number from 2 top numberd rows

ttmtake · 01-27-2009, 02:12 AM

Hi, i need little help with this.

I have mysql like this:

PHP Code:


			
id          browser            country
--------------------------------------
1            MSIE               Japan  
2            MSIE               Europe 
3            FIREFOX            Canada
4            MSIE               Canada 
5            FIREFOX            Europe 
6            MSIE               France 
7            MSIE               USA
8            FIREFOX            Europe 
9            MSIE               Dansk

Now i need to get number of rows for 2 top used countys, in this case that is 1=Europe and 2=Canada, so need to get $europe = 3 rows AND $canada = 2 rows.

I cant just count rows becouse i dont know which country is in most rows.

01-27-2009, 02:12 AM	#1 (permalink)
ttmtake The Wanderer Join Date: Jan 2009 Posts: 8 Thanks: 0	How to get row number from 2 top numberd rows Hi, i need little help with this. I have mysql like this: PHP Code: id browser country -------------------------------------- 1 MSIE Japan 2 MSIE Europe 3 FIREFOX Canada 4 MSIE Canada 5 FIREFOX Europe 6 MSIE France 7 MSIE USA 8 FIREFOX Europe 9 MSIE Dansk Now i need to get number of rows for 2 top used countys, in this case that is 1=Europe and 2=Canada, so need to get $europe = 3 rows AND $canada = 2 rows. I cant just count rows becouse i dont know which country is in most rows.