Detailed Search Script
there is 1 table which has got
id | week_no | continent | country | state | city | town | village | population
we want to a search script; like that.
if somebody search a country (for example country1) script will find all country1 entries in country column and will write only “Country1 and sum of populations. ”
in the form;
– user can be select week (will searched in week_no column – all unique entries will be listed once) (user can be choose multiple weeks)
– user can be choose (if he wants multiple) continent (will searched in continent – all unique entries will be listed once) than user can select countries which has got choosen continents in the table (all countries will be listed once); than user can select states which has got choosen countries…. and go on like that.
for our script;
continent > country > state > city > town > village