pesudo code challenge

[k994519]

hi guys,

how would one make this pesudo code into proper php code

first a little background,

i have a table called users_details which has 3 fields : user_id
username and module_id. this is to be filled out by user in a form.

I have ANOTHER table called modules which has module_id and module_details.

In the form created I have got 2 blank text fields for the user to enter user_Id and username the 3rd element in the form should be a drop down menu which is populated by the field module_id in the table MODULES. I am however havin trouble populating the drop down menu.

Now to the pesdo code

query select module_id from table [b]modules[/b]; 

$row = make sure each result from the query is one row...... 

while ($row=mysql_fetch() , $result);
echo "<option> $row[0] ,\n");*

*this should loop though all the rows in the field module_ID

I know this is at best messy but I am in desperate need of ur help

[mmilano]

something like this should work:

<?
// 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] . ">" . $row[1] . "</option>\n";
}

echo "</select>\n";
?>

[mmilano]

take it 1 step further now.

when displaying this form to the user, make it so the current module is already selected in the drop down box:

<?
// 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";
?>

hope this helps =)

[k994519]

Thanks mmilano

it works truly magnicifently

one question However

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

[AdamBrill]

Hmm... a double post? http://www.phpbuilder.com/board/showthread.php?s=&threadid=10272270