MySQL Select Query Problems

That is his

Anyway, thoses results from the db will be pulled into an array right? Why not just count the array instead of the database?

btw really nice pictures, i looked at quite a few. Nice trip it must have been.
solution was to get the all records according to city name from table ... and you have done
some times mysql queries don't run due to qoutes one good solution that I use is I run the quries in mysqladmin which provides me queries formated with all the quotes add and then I paste it on my php/mysql scripts .
It avoids many confusions.
There are 3 types of qoutes
double quote " "
single quote '
block quote `
be carefull while using them, can safe you from lot of headache and can put you in headache...