Skip to content
PHP Logo

How can the SQL query be modified to prevent the syntax error in the ORDER BY clause?

The syntax error in the ORDER BY clause can be prevented by ensuring that the column name specified in the ORDER BY clause matches a valid column in the table. If the column name contains special characters or spaces, it should be enclosed in backticks (`) to avoid syntax errors.

php 
// Original SQL query with syntax error in ORDER BY clause
$sql = "SELECT * FROM users ORDER BY user_name DESC";

// Modified SQL query with backticks around column name in ORDER BY clause
$sql = "SELECT * FROM users ORDER BY `user_name` DESC";

Related questions