INSERT dynamic values problem - Need help urgently!
| From: | irinchiang at justeducation dot com | Date: | Fri, 27 Feb 2004 15:26:27 +0000 |
| Subject: | INSERT dynamic values problem - Need help urgently! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33194@lists.php.net to get a copy of this message | ||
Hi all:
I am trying to create a registration form whereby one of the user input is as
follows: (a drop down menu with values retrieved from DB):
-----------------------------------------------------------------------------
<td class="lighter" width="350">Class Code:</td>
<td class="lighter" width="450">
<select class="textarea" name="class_code">
<?
$sql = mysql_query("SELECT DISTINCT class_code FROM class");
while ($row = mysql_fetch_array($sql))
{
print "<OPTION VALUE=\"$class_code\" >" .$row["class_code"].
"</option>";
}
$result = $db->query($sql);
?>
</select>
-----------------------------------------------------------------------------
My problem was:
1. I was unable to print the values I have selected from this drop down menu
and
2. insert this "dynamic values" into the DB??
I was able to insert static values into DB but not "dynamic" values...
How should I go about doing this?
Really need some help here...
Thanks in advance. All help are greatly appreciated.
Regards,
Irin.