counting variabel from text file

[tukang_minta]

hi there,....

i have file address.txt, it's content of address of customer, like this ;

name age city
jony 27 new york
george 25 dallas
mony 23 mexico
edward 30 new york
budy 22 dallas
dennise 21 new york

hox to count the field of city, so the result is, like this

city count
dallas 2
new york 3
mexico 1

so i know how many user from a specific city, for the information i am not using mysql. Is that to difficult to do it with out mysql...??

thanx

[steadyguy]

It'd be WAY easier with a db.

[procoder]

Here is a way

Load each line into an array.

run a loop

for($arrays as $line)
{
another loop here to check that line in a array, and for each matching result +1 to the count
}