mysql error
| From: | Richard Kurth | Date: | Sun, 05 Dec 2004 21:05:43 +0000 |
| Subject: | mysql error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-203539@lists.php.net to get a copy of this message | ||
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'";
--
Best regards,
Richard mailto:rdkurth@directphp.com