killer question for killer minds

[k994519]

Hey guys

here is the question which i think will test the best of minds.....

from th code below how can i get the choice selected on the list (i.e module details) into another table called users, but inputting the module_id instead of the module_details

any help will be truly appreicated
PHP:

<? 
// the user's existing module id 
$existing_module_id = 3; 

// query db for info 
$result = mysql_query("select module_id, module_details from modules order by module_id"); 

echo "<select name=\"module\">\n"; 

// loop through results 
while($row = mysql_fetch_row($result) 
{ 
  // the value is the module id, but the module details is what the user sees. 
  echo "<option value=\"" . $row[0] . "\"; 

  // if the existing module id matches the current row 
  if($row[0] == $existing_module_id) 
  { 
    // make this option selected 
    echo " selected"; 
  } 

  echo ">" . $row[1] . "</option>n"; 
} 

echo "</select>n"; 
?> 

[AdamBrill]

I'm not sure if I understand correctly what you are trying to do. This page will submit to another page, where you want the selected module_details to go into the users table, but you want the module_id that matches the module_details, correct?

If so, you will probably have to run two queries. The code should look similar to this, so you should at least be able to see what's going on.

$result = mysql_query("SELECT `module_id` FROM `modules` WHERE `module_details` = 'the module_details from the form';");
$row = mysql_fetch_row($result);
$insert = mysql_query("INSERT INTO `users` VALUES('','" . $row[0] . "');");

This will obviously have to be changed slightly to work with your database and your form...