Can never seem to get things to work!
<?php if(isset($_POST['add'])) { $person_id = $_POST['person_id']; if (isset($_POST["cv"])) { $cv=1; } else { $cv=0; } if (isset($_POST["document_id"])) { $document_id=1; } else { $document_id=0; } if (isset($_POST["application_form"])) { $application_form=1; } else { $application_form=0; } if (isset($_POST["passport"])) { $passport=1; } else { $passport=0; } if (isset($_POST["criminal_disclosure"])) { $criminal_disclosure=1; } else { $criminal_disclosure=0; } if (isset($_POST["medical_clearance"])) { $medical_clearance=1; } else { $medical_clearance=0; } if (isset($_POST["reference"])) { $reference=1; } else { $reference=0; } if (isset($_POST["educational"])) { $educational=1; } else { $educational=0; } if (isset($_POST["passport_photo"])) { $passport_photo=1; } else { $passport_photo=0; } if (isset($_POST["innoculation"])) { $innoculation=1; } else { $innoculation=0; } $sql = "INSERT INTO `teaching`.`documents` (`document_id`, `person_id`,'cv','application_form','passport','criminal_disclosure','medical_clearance','reference','educational','passport_photo','innoculation') VALUES ('NULL', '$person_id', '$cv','$application_form','$passport','$criminal_disclosure','$medical_clearance','$reference','$educational','$passport_photo','$innoculation')"; Bunch of check boxes that need to be saved. Below is the error.
Could not enter data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cv','application_form','passport','criminal_disclosure','medical_clearance','re' at line 1
Where have I gone wrong this time? Thought if I cycled through each checkbox it would work?
