dynamic populated dropdown from mysql database

[mainul05]

hi,
i m newbie php+mysql. in i have the following problem. i tried my best to solve it but could do it. please help me.

i have a from where 3 fields are STATE, AREA and SUBRUB. AREA is connected with STATE and SUBRUB is connected with AREA. when a person will select a STATE the corresponding AREA will be available in dropdown box. and when a AREA is selected the corresponding SUBRUB will be available in a dropdown box. please help me with the solution.

best regards,
Mainul

[TheServant]

I am guessing that you are not submitting the form between changing STATE, AREA and SUBURB... if you are, you shouldn't.

That is a javascript/AJAX task, as once the page is on your screen, PHP is finished. Look here or just search in Google for the difference between Client side and Server side.

[prabirchoudhury]

ok here is the sudo code

1.

$query1=mysql_query("SELECT DISTINCT AREA ,AREA _id FROM AREA  where STATE_ID = $ID");
 
 
  dropdown1 <select name=dd1> <option value=''>Select Area</option>
    <?php
 
      while($row1= mysql_fetch_array($query1)) {
       echo "<option value='$row1[AREA _id]'>$row1[AREA]</option>";
 
      $query2=mysql_query("SELECT DISTINCT SUBRUB,SUBRUB_id FROM SUBRUB where SUBRUB_id = $row1[[AREA _id]");
 
      // dropdown 2
     echo "<select name=dd2> <option value=''> select SUBRUB ..</option>";
    while($row2= mysql_fetch_array($query2)) {
       echo "<option value='$row2[SUBRUB_id]'>$row1[SUBRUB]</option>";
 
    } // end of second while
 
   echo </select>
 
   }  // end of first while
 
echo "<select>"
 

could have a look on here
basic tutorial

:))

[TheServant]

prabirchoudhury, that will only display a static dropdown list? Unless I have missed something. But mainul05, if you combine prabirchoudhury's script with a little javascript or AJAX, and you will have your solution.

[prabirchoudhury]

Y you are right
that javascript part he should get the tutorial link i have added. TheServant ,thanks for your mention.

:))