Code: Select all
$stud_name = $_POST['stud_name'];
$stud_id = $_POST['stud_id'];
$password = $_POST['password'];
$email = $_POST['email'];
$username = $_POST['username'];
//submit changes to DB
$sqlSubmitChanges = "UPDATE tblStudent
SET stud_name ='$stud_name',
username = '$username',
email = '$email'
WHERE stud_id = '$studentID'";
$resSubmitChanges = mysqli_query($mysqli, $sqlSubmitChanges) or die(mysqli_error($mysqli));What am I missing? (I took the password line out of the update query just in case I didn't have that syntax right, but it still doesn't run.)
Thanks.