DEar all please help...

i have two tables .
regionlist
   Rid
   Rname

district
   District_Id
   District_Name
   Rid

now i want to create a form where i should have this both in dropdownlist

so when ever i select region its associated district should appear in next droplist

can anyone help

hi moizshabbir,

welcome to p2p!

when user selects region
reload the page using the selection of dropdown,

take the region and make another query like
select * from district where Rid= "selected rid"

for populating dropdown
thinking you fetched data to an array using sql

for($i=0; $i < count($arr); $i++)
echo <option value=". $arr[$i] .">" . $arr[$i] . "</option>";


jomet.
`````````````````````````````````````````````````` ``````````````````````
Once you start a working on something, dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.