Stuck on MySql Query

[harleyh]

I can't for the life of me figure out why this won't work....

 

SELECT * FROM buyer_listings
  WHERE acct_type='FHA' AND
   buyerCity='Hollywood' AND
   bedrooms>=1 AND
   baths>=1 AND
   ($val BETWEEN sqf_min AND sqf_max, $val2 BETWEEN price_min AND price_max);

 

Error; Operator AND should contain 1 column.

 

 

[Pikachu2000]

I believe:

($val BETWEEN sqf_min AND sqf_max AND $val2 BETWEEN price_min AND price_max);

[akitchin]

not sure why you're using:

 

($val BETWEEN sqf_min AND sqf_max, $val2 BETWEEN price_min AND price_max);

 

that breaks the MySQL syntax. try:

 

SELECT * FROM buyer_listings
  WHERE acct_type='FHA' AND
  buyerCity='Hollywood' AND
  bedrooms>=1 AND
  baths>=1 AND
  $val BETWEEN sqf_min AND sqf_max AND
  $val2 BETWEEN price_min AND price_max

 

if that doesn't work, you may need to specify the BETWEEN requirements separately (ie. sqf_min <= $val AND sqf_max >= $val).

 

EDIT: beaten to the punch, leaving this on because i don't want to have wasted all this finger pressing