php - How do I populate a table with values from a dropdown box? -
i have 3 tables , 2 dropdown boxes. have populated 2 of tables , entered values dropdown boxes. now, choose value both of dropdown boxes , put values third dropdown box.
<fieldset> <legend>new cast</legend> <table> <form action="04castdb.php" method="post"> </fieldset> <?php $query = "select * dbhx_movie"; $result = mysql_query($query); if(!$result) { die("query failed"); } echo "<select name='movie'>"; while($row = mysql_fetch_array($result)) { echo "<option value='$row[pk]'>$row[name]</option>"; } echo "</select>movie</br>"; echo "<select name='actor'>"; $query = "select * dbhx_actor"; $result = mysql_query($query); if(!$result) { die("query failed"); } while($row = mysql_fetch_array($result)) { echo "<option value='$row[pk]'>$row[surname]</option>"; } echo "</select>actor</br>"; echo "<input type='submit' value='swag'/>"; ?> </table> </fieldset>
this code have used populate dropdown boxes. when press submit, doesn't enter data chosen values. can make sense of it?
Comments
Post a Comment