Hello everyone!
In my mySQL DB I have the tables:
| po_product | and | products |
|----------------------| | ---------------------|
| po_id | | product_id |
| product_id | | product_name |
|----------------------| |----------------------|
With the folowing code I build a dropdown list whith the product names....
$get_list = "select product_name from products";
$res = mysql_query($get_list) or die (mysql_error());
while ($row = mysql_fetch_array($res))
{
$option_block .= "<OPTION value=\"$prd\">$prd</OPTION>";
}
I want to store into another table in my DB the product_id that corresponds to the
product_name that the user has selected....
Any help greatly appreciated.
George
