Re: INSERT dynamic values problem - Need help urgently!

Irin, 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. i.e. 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, irinchiang@justeducation.com 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); ?> </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. --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php