FORM not inserting data
| From: | Neil | Date: | Fri, 26 Apr 2002 01:34:38 +0000 |
| Subject: | FORM not inserting data | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18820@lists.php.net to get a copy of this message | ||
Help. Help
Please, Please tell me what I am doing wrong here...I have a form to input data but it is not
posting it....here is the code. It seems to work no errors but a query show no new additions to the
table.
$sql = "INSERT INTO employees (first,last,address,date_of_birth,sex,age,telephone,
parent_guardian_name,parent_guardian_workplace,work_telephone,emergency_information_contact,
list_physical_conditions_if_any,all_schools_previously_attended,examinations_passed,older_brothers,younger_brothers,older_sisters,younger_sisters,
names_sisters_or_brothers_attending_school) VALUES
('$first','$last','$address','$date_of_birth',$sex','$age','$telephone','$parent_guardian_name','$parent_guardian_workplace',
'$work_telephone','$emergency_information_contact','$list_physical_conditions_if_any','$all_schools_previously_attended','$examinations_passed','$older_brothers','$younger_brothers','$older_sisters','$younger_sisters','$names_sisters_or_brothers_attending_school')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
} else{
// display form
?>
Neil