Select Country to show state from mysql

[rmoloruntoba]

can I get code to bring out the state under a country when the country is selected. both state & country from the database displayed in a select dropdown

So what do you want from us? Show your code if you want help with it. I take it you weren't expecting us to write something for you.

[rmoloruntoba]

I actually want to use it for selecting staff in a particular department.
I need what to write inside function displayStaff;

$tp='
<select name="department" onchage="displayStaff()">
while(list($x,$v))=each($department){
$tp.='
<option value="'.$v[dept_nr].'">';
$tp.=$v[departments];
$tp.=' </option>  ';
}
echo $tp.="</select>";





<select name="staffs">

...the staff for selected department should come up
but all the staffs do come up

</select>

[mattster]

Take a look at this:

http://www.webdevdoor.com/javascript-ajax/dynamic-select-list-jquery-php/

It's a good idea to use AJAX in a situation like this to smoothen the browsing experiance, but at the same time being able to use a dynamic list.

https://www.daniweb.com/web-development/php/code/476623/ajaxed-linked-dropdowns-select-fields-for-volatile-data

https://www.daniweb.com/web-development/php/code/475238/linked-dropdowns-select-fields-for-static-ish-data

May help