Database Professional

* This is for work on an ADULT based website. If you are offended by adult material, please do not bid. Our site is a Personals Dating Community. We have 3 known issues that need resolved. PHP and MySQL ## Deliverables 1. Our site has a script feature where: When user performs a search and (our database) does NOT have any members there?our site will then "grab" x amount of profiles, and change their location to the search result. We need this to function correctly. If you have a better solution for this, we are open to it. So for this Issue, will need: 1a) Fix the (grab profiles if 0 result) feature. 1b) Fix profiles in the DB that have missing and/or incorrect city, state, zip fields. 1c) Ensure all search tools (home,basic,advanced) are functioning properly. ==================== 2. Not showing correct "distance" between two profiles. Some profiles show the distance and some do not. We need ALL profiles to show correct distance. (this may be resolved when Issue #1 is fixed). ==================== 3. On the BASIC Search Form, under "who is seeking", it shows an answer/checkbox of "[login to view URL]". Of course this should NOT be there.