[SOLVED] You have an error in your SQL syntax

[plutomed]

Can anyone tell me what this means and how i can solve it?

 

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 show='1'' at line 1

[Archadian]

please post the code you are having problems with

[plutomed]

$result = mysql_query("SELECT * FROM templates ORDER BY id DESC LIMIT " . $start_from . ", 5 WHERE show='1'") or die(mysql_error());

[Archadian]

I believe LIMIT goes after WHERE if im not mistaken

 

Also, try '$start_from' instead of " . $start_from . "

 

I've gotten errors like that before because of that

[plutomed]

it doesnt like the where command for some reason ??? because wherever i put it at repeats the code after it

 

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 show='1' LIMIT 0, 5' at line 1

[Archadian]

try putting the WHERE after FROM templates

[plutomed]

no but its in the right place because it says show='1' not WHERE show='1'

 

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 'show='1' ORDER BY id DESC LIMIT 0, 5' at line 1

[AndyB]

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

show is a reserved word and should NOT be used as a column (field) name.

[plutomed]

thankyou but i fixed it its:

 

$result = mysql_query("SELECT * FROM templates WHERE `show` = 1 ORDER BY id DESC LIMIT " . $start_from . ", 5") or die(mysql_error());