PHP drop down assistance needed.

[ksharpesays]

I am trying to make a database of college bars, organized by school. I created a form for bars to add themselves to the database that can be found at http://sofnthirsty.com/kevin/bar.php?act=add Ideally- for those of you who looked at the form - I would like to have the Nearby School/University drop down display a list of Schools in a given state. For example: When someone selects NJ in the State dropdown above- the Nearby School/University menu would show Rutgers, Stockton College, Kean, Farleigh ****inson, Seton Hall, Princeton, Montclair, Rowan, etc etc. so I need to change the code below accordingly. Any help would be appreciated, I hope I gave you guys enough information to be able to provide assistance.. Here is the code so far:

  <tr>
        <td class="fieldheading">State</td>
        <td><select class="ddown" name="bstate" id="bstate" style="width:231px">
        <?php 
    foreach( $states as $key=>$value)
    {
?>
        <option <?php if($value=="AL"){echo 'selected="selected"';} ?> value="<?php echo $value;?>"><?php echo $key;?></option>
        
        <?php } ?>
    </select>
    </td>
      </tr>

      <tr>
        <td class="fieldheading">NearBy School/University</td>
         <td>
         <?php 
              $qry_schools = "SELECT * FROM ".$tblprefix."schools"; 
            $rs_schools  = $db->Execute($qry_schools);
           ?>        
            <select class="ddown" name="bschool" id="bschool" style="width:231px">
                 <?php while(!$rs_schools->EOF){?>
                    <option value="<?php echo $rs_schools->fields['id'];?>">
                        <?php echo $rs_schools->fields['name'];?>
                    </option>
                        <?php $rs_schools->MoveNext();
                          } 
                        ?>
            </select>                
        </td>
      </tr>

[erilidon]

You are going to have to do this with javascript. I don't have any codes that I have written that do this but it can be done. search google for something like "javascript form Change Dropdown menu by other menu" Also found this link with a working example.

http://www.trans4mind.com/personal_d...tripleMenu.htm

Good luck.