then now i'm trying to select a value from the drop down list, echo the value 
i have selected and lastly INSERT the value into DB with the following :
Below's a snippet of code:

//retrieve all "tutor_name" from DB and display in drop down list

<SELECT class="textarea" name="tutor_name" />

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



***********************INSERT selected values into DB**************************
$tutor_name = $_POST["tutor_name"];

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

//execute query statement
$result = $db->query($sql);


*********************echo the value i have selected***************************
if($selected_tutor_name == $tutor_name)
echo $_POST["tutor_name"];


Problem: I was unable to echo the value i selected from drop down as well as 
INSERT into DB...wonder where have i gone wrong???
Reali need some help here...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