Pull Mysql For Most Common Locations Entered

ok need help with this.

so far i have

open header.php

put it in header where i wanted to display it

then opened gb.class.php

AFTER

I ADDED THIS

Unfortunately, WHERE location = Arizona ..

is giving me an mysql error.

do you know how i can change it to make it work?

I'm guessing i have to say that arizona is the value somehow and thats what i'm missing.

Any help would be much appreciated

well i might be missing other stuff..

How would i use that to display the number of people with arizona as their location?

meh where you see the gender i actually had it as location *