HELP!! I've searched the forum and all the references to wildcards seem to be for searching for words but I can't find anything for numbers and the % doesn't seem to work.
What I have is a data base of homes which specifies No. of Bedrooms, Max Occupancy and Location. What I want to do is have an advanced search which lets you select a specific number or All. If all are selected then I want to pickup everything? I've tried putting % in a variable and in the MySql query e.g.no_bedrooms = '%$noofbeds%' but none of them work.
Any help would be appreciated.