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