> 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'";
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
