Re: Syntax Error - Syntax for 'LIMIT 1'
The cause is simple: $subject_id is empty
So when the PHP code is parsed, MySQL sees the following query:
SELECT * FROM subjects WHERE id= LIMIT 1
which is obviously wrong. As a proof, add:
echo $query . "\n";
somewhere before running the query. You'll see what I mean.
Aurelien
Edited 1 time(s). Last edit at 04/11/2012 07:58AM by Aurelien Marchand.
Subject
Written By
Posted
Re: Syntax Error - Syntax for 'LIMIT 1'
April 11, 2012 07:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.