I'm making a search page to view properties of certain characteristics (ie 2 bedrooms, 1 bathroom etc). I'll pass on the choices of the users as variables from a form. What I want to know is how to include an 'any value' in the WHERE statement ie SELECT ....... WHERE bedrooms = 'any value' AND bathrooms = '1' AND ...
My problem is how to make MySQL understand 'any value'. There is no doubt a simple answer as it must be possible....
Help please!




Bookmarks