Re: RE:PHP | MySQL Search

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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

########################################################## # Rick St Jean, # rstjean@internet.look.ca # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ##########################################################