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.


<html>
<head><title>hjhj</title></head>
<body>

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

&lt;?php

require(“connect.php”);
$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>
</select>
<input type=“submit” name=“Submit” value=“Submit”>
</form>

&lt;/body&gt;
&lt;/html&gt;

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

Here is my vod0011.php


<?php
error_reporting(0);
require(“connect.php”);
$buyr = $_POST[‘buyr’];

$query=“SELECT * FROM tbl_order, tbl_buyr, tbl_fact1
WHERE
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”;
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>


Kindly advise why???

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