RE:PHP | MySQL Search
| From: | Dennis Gearon | Date: | Wed, 14 Mar 2001 03:12:21 +0000 |
| Subject: | RE:PHP | MySQL Search | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-43759@lists.php.net to get a copy of this message | ||
I never have luck putting single quotes around anything but strings, or
column names when called for. You might try your SELECT statement
without 's
>Query 1 :
>
>(I only want result on houses which are in country 2 and in price 3 and
>facility 1 must be included on the spot)
>
>I've used :
>
>SELECT HouseID FROM Search WHERE CountryID='2' AND PriceID='3' AND
>(FacilityID='5')