query="SELECT * FROM listing WHERE state = 'WA' AND type = 'RES'
AND county = 'clark' AND (price > '150000' OR price <= '200000');";
if that doesn't work - break it down into individual parts and find out where the problem is.
Respectfully,
Ligaya Turmelle
---
Life is a game... so have fun.
---
www.PHPCommunity.org
Open Source, Open Community
Visit for more information or to join the movement
Richard Kurth wrote:
Could somebody tell me way these query gets a error 1064 and does not
work.
error=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
'"SELECT * FROM listing WHERE state = 'WA' AND type = 'RES'
query="SELECT * FROM listing WHERE state = 'WA' AND type = 'RES'
AND county = 'clark' AND price > '150000' OR price <= '200000'";