Display data beside select option after option selected

[newphpbees]

Hi..

I have a select option where the data came from database and I use php codes for displaying the data to select option. And it works, now I need to display bin_loc base on what lot_number that I choose.


I want to happen is after I choose lot number the bin_loc for that lot_number will also displayed.
here is my code in displaying lot_number:



$query = "SELECT lot_number from wms WHERE (date_shelve IS NOT NULL) AND stock_item = '$ItemCode' AND (qty = orig_qty OR qty != '0.00') AND qty >= '$SubQty' ORDER BY qty";
$rows = mysql_query($query, $con);
echo "<td><select name = 'lot_number' id='lot_number'>";
echo "<option></option>";
while ($record = mysql_fetch_array($rows))
{
echo "<option value = '{$record['lot_number']}'";
if ($lot_number == $record['lot_number'])
echo "selected = 'selected'";
echo ">{$record['lot_number']}</option>";
}
echo "</select>";
echo "</td>";


now I need to display bin_loc in <td></td> after the lot_number;

I tried this:


$sql = "SELECT bin_loc FROM wms WHERE lot_number = '$lot_number'";


but it did not work cause I can get the value of option that I selected.

I hope someone can Help in automatically displaying bin_loc.

Thank you so much