i need help with this following code, php and my SQL

Given the markup shown just below, write the PHP and the rest of the markup necessary to display the country names from the Countries table (id, name, capital, population) in a drop-down list. When the user clicks the submit button, the page should then display below the drop-down list the capital and population of the selected country. Assume that this page is called country.php.

Here is sample run of the script: (Before clicking Submit)

After you click on Submit:

What to turn in:

country.php

A screenshot of your countries table including at least five entries. Something similar to the following:

a Labs cscl 2006-90 In x Sample Zakaria 8888/labs/lab7/countr ocalhost EE Apps D2L Brightspace L E Microsoft My Account Other Bookmarks Select a country France SUBMIT