Hi all, 

       Right now i would like to INSERT the values from a dynamic drop down 
menu into mysql database but encountered some problem here. Values in the drop 
down menu are retrieved from DB as follows:


<SELECT NAME="tutor_name" CLASS="textarea">

$sql = mysql_query("SELECT DISTINCT tutor_name FROM tutor");
while ($row = mysql_fetch_array($sql))
 print "<OPTION VALUE=\"$tutor_name\" >" .$row["tutor_name"]. "</option>";
$result = $db->query($sql);




echo $_POST["tutor_name"];

INSERT statement:

$sql = "INSERT INTO class (class_code, tutor_name, edu_level, timetable_day, 


I am trying to POST the values and then INSERT into DB but was not able to do 
so....(all other values eg. class_code, edu_level etc...was able to be 
INSERTED into DB but not "tutor_name". So, how do i insert values into DB from 
a dynamic drop down and where have i gone wrong???Hope to get some help real 

All help are greatly appreciated. Thanks in advance.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to