Get Values after a mysql_query

[Anon]

Hallo...

I have a database with different cities inside. I get the name and the sum of these cities with the command :

SELECT city, count(*) AS FCount
FROM country
GROUP by city

so that the result looks like :

Hamburg 5
Berlin 3
...

Which command allows me to get a special part of this result, e.g. only "Hamburg" and after this in another variable the sum of "Hamburg" -> "5" ????

Any idea ???

Thanks

[[deleted]]

This is a clear-cut case of "Read the manual".
Everything you need to know about doing queries and getting data back is in the manual.