I have a web search form to search propety types on a real estate site database. I want to be able to search by reference number if a refernece number is added and display only the property with the relevant ref otherwise the other seach criteria show all the properties that meet the criteria.

An example of this is www.vivaestates.com where the serach form will display all properties if left the referenec is left blank and only the prperty with the reference number if it is present.

How do I add this in dreamwever my sql for the existing syystem is>

SELECT *
FROM Proeprt
WHERE Price BETWEEN Varmax AND VarMin AND Areaname LIKE Varareasort AND types.PropertyType LIKE VarTypes AND Bedrooms LIKE VarBeds