Development SQL question/help

http://www.29er.org.uk/css/index.php

Just creating this website. could someone help me with my SQL.

PHP:

$query="SELECT * FROM 29ersite_home WHERE feature = 0 and show = 1 ORDER by id DESC";

I just get the error message that is shown on the site. Yes there is contents, and when i remove the AND and one of the arguments it works as i would expect it to.

Cheers

Andy

 

I think show is a SQL reserved word. Try renaming the field to something else and see if that works

 

SHOW is indeed reserved word for SQL. Try putting show in single quotes and it may see it as a variable or string.

"SELECT * FROM 29ersite_home WHERE feature = 0 and 'show' = 1 ORDER by id DESC"

 

i thank you!

 

edit: see SJH's post

 

Wiser words have never been said

 

is it me or does this site look awfully familiar....

 

Haha I didn't notice that to start with

 

Imitation is the sincerest form of flattery

 

indeed, well i do spend a few too many hours reading this site, and love it.

Its also not a complete copy, you goto love my graphics!