Populting dropdown menu from data base & select value to view details from DB in php

Dear All
I am using below script to populate the drop down menu & its working fine.


Select Car:
<form method=“post” action=“vod0011.php”>
<label for=“select”><select name=“buyr” value=“buyr” size=“1”>


$sql = “SELECT distinct buyr FROM tbl_buyr “;
$result = mysql_query($sql) or die (mysql_error());
while ($row = mysql_fetch_array($result))
$tbl_buyr_id = $row[“tbl_buyr_id”];
$buyr = $row[“buyr”];
$options.=”<OPTION VALUE=\”$tbl_buyr_id\“>”.$buyr;

<option value=“$options”> <?php echo $options ?> </option>
<input type=“submit” name=“Submit” value=“Submit”>


But when i select the data & submit the form it doesn’t retrieve any details from database.

Here is my vod0011.php

$buyr = $_POST[‘buyr’];

$query=“SELECT * FROM tbl_order, tbl_buyr, tbl_fact1
buyr =‘$buyr’
AND tbl_order_id=buyr_tbl_order_id
AND tbl_order_id=fact1_tbl_order_id
AND ship_status > 0 ORDER BY shipmentdate, buyh, buyr ASC”;



Kindly advise why???

Hi Every one!!! I got the solution. Thnx