Quick Question Everybody

[Nixon]

Hi, This query selects all the records whether or not thier status is set to 1.

select * from classifieds where guitar='1' OR guitar='2' or guitar='3' or guitar='4' or guitar='5' or guitar='6' and status='1' order by timeend asc

Any ideas?

Thanks. Jack

[AstroTeg]

You need parenthesis around all your guitar statements, so...

select * from classifieds where ([guitar stuff]) and status='1'

[Nixon]

So.

select * from classifieds where [ guitar='1' OR guitar='2' or guitar='3' or guitar='4' or guitar='5' or guitar='6' ] and status='1' order by timeend asc

Thanks.

[Nixon]

Got it, Thanks!