PHP/MySQL apartment search results page

I have an apartment search website under development but am having a hard time developing the "amenity search" funtion and results page. It is based on PHP and MySQL. The database structure is developed and some sample data is entered. Everything is there, I just need help pulling it back out in the most efficient manner possible. To sum things up quickly, I need a seach results page that functions almost exactly like [login to view URL], with a few small additional requirements which are outlined in the attachment. Please review the attachment. This is a serious project. Heavy PHP and MySQL experience is a must. You must be able to pull data from multiple tables in the most efficient manner possible and present accurate results to the user. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). 4) Code must be fully commented and notes made as to the logic behind each function and any unique methods used so that sense can be made of the code. * * *This broadcast message was sent to all bidders on Friday Jul 7, 2006 10:00:57 AM: Several bidders have requested to see the database tables/structure. Unfortunately there is a table called 'GeoData' which contains zip code data from www.zipcodedownload.com. I am forbidden from distributing their data due to the license agreement. However, I will remove most of the data and leave enough relevant data to do testing. I will upload a sql file for you to import within the hour. Please check for it and reply with your thoughts... Thanks, Dan * * *This broadcast message was sent to all bidders on Friday Jul 7, 2006 3:28:52 PM: Hello, I have uploaded a new .zip file containing database structure and sample data, as well as a few other files. Please revisit this bid request and download the new file. Thanks for your consideration. Dan * * *This broadcast message was sent to all bidders on Friday Jul 7, 2006 5:58:14 PM: Thanks to everyone interested in this project. I have received several good follow-up questions. I'm posting one here that I think is important. The main sorting will be done on the number of amenities matched. For instance, if the user selects the following: Community features ================= business center clubhouse doorman elevator garage parking Apartment features ================= air conditioning balcony dishwasher fireplace That means they have selected 9 amentities that they want to search for. The search does not have to match every single one of these. Rather if a building in the database matches 9 out of 9 then it should be shown at the top of the results. If a building matches 7 out of 9 then it will be shown below the other one, and so on. The user can override the default sorting on their own through controls on the results page. For instance: - l owest to highest price - highest to lowest price - most matches to fewest matches and - fewest matches to most matches. Additionally, the default will be 10 results per page. The user should have controls to advance through the results by page # and 'previous' and 'next' links. Hope that helps clarify some things. Please let me know if you have any questions. Thanks. ## Platform PHP 4.4.2 MySQL 4.1.19-standard Linux Apache version 1.3.36 (Unix) These are my server specs. Additional configuration info can be given upon request. You must provide your own development environment as I can't give you access to my server.