如何解决“您的SQL语法中有错误。”错误消息

Question

here is my code

$sql14 = ("SELECT count(`MarksID`) AS all FROM tbl_course_marks_result WHERE tbl_course_marks_result.`StudentID` = '$k' AND tbl_course_marks_result.`CourseID`='$courseID' AND tbl_course_marks_result.`SessionID`='$sessionID' AND tbl_course_marks_result.`TermID`='$termID' ");
    $result14 = mysqli_query($connect,$sql14);
if($result14 === FALSE) { 
    die(mysqli_error($connect));
}

here showing this error message " You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'all FROM tbl_course_marks_result WHERE tbl_course_marks_result.StudentID = '17' at line 1" How to solve this???

Answer 1

All is a reserved keyword.Use a different alias name like below

 $sql14 = ("SELECT count(`MarksID`) AS all_marksid FROM tbl_course_marks_result     WHERE tbl_course_marks_result.`StudentID` = '$k' AND  tbl_course_marks_result.`CourseID`='$courseID' AND tbl_course_marks_result.`SessionID`='$sessionID' AND tbl_course_marks_result.`TermID`='$termID' ");
$result14 = mysqli_query($connect,$sql14);
 if($result14 === FALSE) { 
die(mysqli_error($connect));
}