Searching between two numerical values

Anon

Hi,

As some of you may know, I'm in the process of trying to make a database that contains the records of houses for sale. As part of this database, I'm making several pages in php - an insert page, an edit/update page, a detail page and a search page. As usual, I'm having problems with the search page - this time it's to do with searching for the price.

On the page, I have many other fields that are being searched for - and they all work fine. But at the bottom of the page I have two fields - Pricelow and Pricehigh. In the MySQL database I have one field containing the price of the property - Houseprice. I need to be able to have these two fields on the search page so the user can search for a property costing between these two fields - but I have no idea how to do this. Can anyone help me?!

Anon

Here are some details:

SQL Statement:

SELECT *
FROM Oval
WHERE Houseaddress2 LIKE '%varHouseaddress2%' AND Housecity LIKE '%varHousecity%' AND Housetype LIKE '%varHousetype%' AND Nobeds LIKE '%varNobeds%' AND Noreceptions LIKE 'varNoreceptions' AND Houseprice BETWEEN '%varPricehigh%' AND '%varPricelow%'

Variables declared:
varPricelow - $Pricelow
varPricehigh - $Pricehigh
(Default values are %)

Field names on the search page for the price fields are: Pricehigh and Pricelow

Values in both fields are numerical in steps of 50000

vsego

I know the meaning of "%" when used with "LIKE", but what does it do with "BETWEEN"? Or is this what's troubling you...

Anon

Hmm...I think using % with BETWEEN is ok - it just means to display any recordset with values between something that is like x and y.
I did solve the problem in the end - and I'm going to get it for this! It turns out that it was just a case of the Houseprice field being a text field rather than an integer - I didn't think this would make a difference anyway seeing as the values inputted would be numerical, but it turns out it did. Whoops.