select option retrieve data

[jamhussain]

Aslam o Alaikum.
I m new in php,
there are 2 tables in database
country table
countryid countryname

city table

cityid cityname countryid

here countryid is foreign key
I m using select option
in html form.
what should be code for HTML, and PHP, so that after selecting country , i may select the city .
then i want to submit these values in form.

[WyCnet]

Don't blame being new to php. You have to flowchart your system needs in a systemic way.
QUOTE Lay out your basic page with all countries in the data base.
(2) When a country is selected search the database for all the cities and place them on the page.
(3) When a city is selected submit (country,city) pair otherwise try (2).[/QUOTE]

Note that there are other more inefficient ways to achieve the same purpose.