[SOLVED] Need help with controling deplicates in a loop.

[forcom]

Table info

 

id country state city

1  usa      ny    sample1

2  usa      pa    sample2

3  usa      nj      sample3

4  England no    sample 4

 

I want to display a unique name no deplicates

 

 

usa (3)

England (1)

 

can this be done. right now my code look something like this

 

usa

usa

usa

england

 

Need help

[Maq]

SELECT DISTINCT country FROM table

 

Do you want the count of each one as well?

[forcom]

yes I would like that. I will try this code now.

[Maq]

This should do was you want.

 

SELECT country, COUNT(*) AS num FROM table GROUP BY country;