[Resolved] MySQL query problems

[aconway]

This is a two part question.

First, I wrote this query:

SELECT * FROM $property WHERE beds >= $beds AND baths >= $baths AND garage >= $garage AND price BETWEEN $price_min AND $price_max ORDER BY price ASC

I thought that it would limit the results, for example if I have $beds=3 then it would return all values of beds greater than and equal to 3 with in the price range specified. However, I am getting values less than 3 in my results.

What am I doing wrong?

Second, if I add a select list where I can select several variables in the search how would I enter them into the query?

[TheDefender]

Part 1: You should quote your values...

SELECT * FROM $property WHERE beds >= '$beds' AND baths >= '$baths' AND garage >= '$garage' AND price BETWEEN '$price_min' AND '$price_max' ORDER BY price ASC

[aconway]

I tried your suggestion, but I am still getting values less than what i want

[TheDefender]

OK, then it's time to step back and make sure all of the variables have the proper values associated with them...

Before your query, echo the following variables:
echo $beds;
echo $baths;
echo $garage;
echo $price_min;
echo $price_max;
echo $property;

Then, if you find they are echoing properly, then you should try hardcoding the values into your query to see how that goes.

SELECT * FROM valueofproperty WHERE beds >= '3' AND baths >= '1' AND garage >= '2car' AND price BETWEEN '50000' AND '100000' ORDER BY price ASC

Give a report back, and we'll go from there... (including the EXACT values being echoed from the variables.

[aconway]

I'm an idiot:rolleyes:

I left a query in my script that was being referenced instead of the one i was working on.

So, now it works

But, if you have any ideas on the multi variable select list and adding that to the search let me know.🙂