First of all, you need to do this instead of what you're doing:
while ($row = mysql_fetch_row($sql))

Second, this value should be storable just as any other values.
mysql_query("insert into database (table) values('" . $_POST['class_code'] . "')");

I hope this helps you a bit.
Regards, Mikael

On Feb 27, 2004, at 15:26, [EMAIL PROTECTED] wrote:

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);



----------------------------------------------------------------------- ------

My problem was:

1. I was unable to print the values I have selected from this drop down menu

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.



PHP Database Mailing List (
To unsubscribe, visit:

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to