How do you select the id row number when in a loop like in the code below?:
  This code above places the text value of $manufacturers_name into f_prod_id. What i would like it to do it actually place the manufacturers_id into f_prod_id so i can back reference it when i come to extract this data from another table.

Any ideas?


Michael.

__________________
Michael.

echo "<select name=\"f_prod_id\" id=\"f_prod_id\">";
while ($row=mysql_fetch_array($mysql_result))
{
  $manufacturers_id=$row["manufacturers_id"];
  $manufacturers_name=$row["manufacturers_name"];
  echo "<option value=\"$manufacturers_id\">$manufacturers_name</OPTION>";
}
echo "</select><br />";

On POSTing this, you'd have the value of $manufacturers_id for the option selected in the variable $_POST['f_prod_id']. In fact, I think only Nozilla/Netscape can cope with implicitly inserting the text of a select in place of the value if no value is given. IE woud definitely choke on it.

Take it easy,
Dan

Simple as that! Excellent.

Thanks D.

Michael.