Syntax error of SQL-statement

Question

I try to get all rows which has a timestamp bigger then a value given in a variable or "0".

$pdo = $db->prepare('SELECT * FROM table ORDER BY id DESC, parent, cat WHERE timest >= :low OR timest = 0');
$pdo->bindParam(':low', $low, PDO::PARAM_INT);
$pdo->execute();

What is wrong with that?

I get a SQLState error 42000 (syntax error), but I don't understand why.

Your syntax is wrong, the order of the clauses is SELECT ... FROM ... WHERE ... ORDER BY. You swap ORDER BY and WHERE by adding some columns after ORDER BY. Please order the parts of your query. — VMai
– VMai, Commented Aug 10, 2014 at 0:01

NoDataFound · Accepted Answer · 2014-08-10 00:01:58Z

1

The query is wrong:

SELECT * FROM table 
WHERE timest >= :low OR timest = 0
ORDER BY id DESC, parent, cat

The query base "format"/grammar is :

select [...]
[from ... [inner | left | right ] join ... [on ... | using ...]]
where ...
group by ...
having ...
order by ...
limit ...

Except for select, all parts are optional.

Better explanation in the mySQL Documentation here.

answered Aug 10, 2014 at 0:01

NoDataFound

12k39 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

VMai Over a year ago

even FROM is optional in MySQL, i.e. SELECT LAST_INSERT_ID(). There's no need for FROM dual as i.e. with Oracle.

Collectives™ on Stack Overflow

Syntax error of SQL-statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related