GeoNames Forum

Searching for days these forums and googled but did not find answer, I am doing something for sure wrong.

I found this query to find the counties, Iam using the dump files not the web services:

#-- Get all counties by state/province ID. Ex: 3844419
#SELECT g.geonameid AS id, g.name FROM geoname g JOIN hierarchy h ON h.childId = g.geonameid AND h.parentId = ? AND h.type = "ADM" ORDER BY g.name ASC;

and I can go through the hierarchy up to:
Continent > Country > State > County

but I can not get the cities/villages/places etc under specific County.

I found some topic here says that I should use google reverse geo to find the county of the city/village.

Also Fields admin2, admin3, and admin4 are almost empty for all the cities/villages and no relation in the hierarchy table.

So in short how to find the cities/villages inside specific county.

I am building combo boxes like this:

Continent > country > state > county > city/village/place etc

and I am stuck now at:

Continent > country > state > county

Please this is my first question here so be patient with me if I am doing something wrong.

Thanks in advance