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')
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]