[PHP] Syntax problem PDO and bindvalue

So I am getting this SQL error: Error selecting photographs: SQLSTATE[42000]: Syntax error or access violation: 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 ''4'' at line 2 My code is: function

Re: [PHP] Syntax problem PDO and bindvalue

I don't think you're suppose to end your queries with a semicolon. Try: $sql = SELECT * FROM photographs WHERE photo_filename LIKE '%2%' LIMIT 0, :q; On Mon, Dec 12, 2011 at 1:49 PM, Stephen stephe...@rogers.com wrote: So I am getting this SQL error: Error selecting

Re: [PHP] Syntax problem PDO and bindvalue

On Mon, Dec 12, 2011 at 4:22 PM, FeIn aci...@gmail.com wrote: I don't think you're suppose to end your queries with a semicolon. Try: you can end your queries with semicolon in prepared statements. How can I see the prepared SQL statement before it is executed? try- var_dump ($statement);