If the fields are all integers then it is:
>SELECT HouseID FROM Search WHERE CountryID=2 AND PriceID=3 AND (FacilityID=5)
Rick
At 07:12 PM 3/13/01 -0800, Dennis Gearon wrote:
>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]
##########################################################
# Rick St Jean,
# [EMAIL PROTECTED]
# President of Design Shark,
# http://www.designshark.com/
# Quick Contact: http://www.designshark.com/messaging.ihtml
# Tel: 905-684-2952
##########################################################
--
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]
