What is the error message indicating in the SQL syntax for the DELETE query in the PHP code?
The error message is indicating a syntax error in the SQL DELETE query in the PHP code. This could be due to missing quotes around the table name or a misplaced semicolon. To solve this issue, ensure that the SQL query is correctly formatted with the proper syntax.
// Corrected SQL DELETE query with proper syntax
$sql = "DELETE FROM users WHERE id = 1";
// Execute the query
if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}