hello i have a dropdown box where i have populated values from the sql database.
no when i select a value from the drop dopwn, i want to display all the records related to that value under the dropdown.
here is my code
<?php
$select=FALSE;
require_once ("configFile.php");
$result=mysql_query("SELECT Registration_No FROM vehicle_master ");
if($result == FALSE)
{
die(mysql_error()); // TODO: better error handling
}
//populate dropdown with vehicles
//echo "<label>Select vehicle number : </label>";
//echo "<select name='vehicles'>";
//while ($row = mysql_fetch_array($result))
//{
// echo "<option value='numberPlate'>" . $row['Registration_No'] . "</option>";
//}
//echo "</select>";
//echo "<br><br>";
// $select=isset($_POST['vehicles']);
?>
<form id="form1" name="form1" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?> ">
<?php
echo "<select name='select'>";
$list=mysql_query("SELECT * from vehicle_master");
while($row_list=mysql_fetch_assoc($list))
{ ?>
<option value="<?php echo $row_list['Registration_No']; ?>"
<?php
if($row_list['Registration_No']==$select)
{ echo "selected"; }
?>>
<?php echo $row_list['Registration_No']; ?>
</option>
<?php
}
?>
</select>
<input type="submit" name="Submit" value="select" />
</form>
<br>
<?php
if (isset($_POST['SELECT'])) {
$Registration_Nos=mysql_real_escape_string($_POST['SELECT']);
$result=mysql_query("SELECT * FROM vehicle_master WHERE Registration_No='".$Registration_Nos."'");
while ($row=mysql_fetch_assoc($result))
{
echo "".$row['Emergency_Contact_1']."";
}
}?>.
can anyone tell me where am i going wrong ?
control.php
