MyBB Community Forums

What am I doing wrong?

Quote:Error
SQL query:

SELECT *
FROM questions
ORDER BY id ASC
WHERE approved =1
LIMIT 1 , 5

MySQL said:

#1064 - 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 'WHERE approved=1 LIMIT 1, 5' at line 1

Refer to the MySQL documentation on SELECT syntax: http://dev.mysql.com/doc/refman/4.1/en/select.html

The "WHERE" part needs to be right after the "FROM" part.

SELECT * 
FROM questions 
WHERE approved =1 
ORDER BY id ASC 
LIMIT 1 , 5