get code from option box

[flashfinger]

hi

i have 2 option box

the first one the option box value was a code (from table1), after users chose the code, then i use the code (option box1) as a key to search in database to find data to fill to option box 2 from table 2, is it possible to do it in one page ?
if it possible what should i search for ?

thks

[flashfinger]

hi again

this is the code

$query="Select * From propinsi";
$result = mysql_query($query, $con) or die('Query failed : ' . mysql_error($con));
echo "Province :";

echo "<select name='propinsi' id='propinsi' class='' tabindex='3'>";
echo "<option value='' selected>- Select Province -</option>";

while ($row = mysql_fetch_row($result))
{
echo "<option value='$row[0]' >$row[1]</option>";
}
echo "</select>";

/* Free result set */
mysql_free_result($result);

//get from table kabupaten//
$query="Select * From kabupaten where code=([B]value from option province[/B])";

i need the "Value from option province"

thks

[bradgrafelman]

To do this, you'd need to output the HTML for the first SELECT element and then use some AJAX code to send their selection back to the server.

You would then process their selection and send back the necessary data to build the second SELECT element.

EDIT: For an example, here is a link I found on Google.