I'm working on a searchable database of properties for a realtor who's invested in some properties down in Florida. While I've got things working with most of the search parameters (price, square footage, number of bedrooms and bathrooms, and number of cars the garage will hold), I'm kinda stumped on something here:
I'm also including a search parameter for number of stories, with the selection possibilities being no preference, one story, one and a half stories, two stories, and split-level. The question is, how am I supposed to make the database select from all "stories" classifications when a user selects "no preference"? True, I could set up an IF statement that would choose between two SELECT queries, one of which would and the other of which would not filter the number of stories, but there's also a field for whether or not one wants a waterfront property, and if I get another such field in there like that where one can select from stuff like that that's not all that easy to do with numbers, unlike the price, square footage, etc., then things will get messy, and I'd like to avoid that if at all possible. Any ideas? I just know that this is possible to do, because I'm sure I've seen something like this done on other websites, but just how is beyond me at the moment. I've used PHP on a few sites before (mostly include statements), but this is the first time I've ever created a site that searches a database. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
