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

**mehidy** · Apr 8, 2012 00:49

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">

<?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>

</body>
</html>

***************************

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???

**mehidy** · Apr 8, 2012 01:15

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

User Tag List

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

Thread Tools

Display

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

Bookmarks

Bookmarks

Posting Permissions