PHP/MySQL Search Tool

I have a MySQL database table that contains a Locality, Title, and MerchantID number. I need to be able to perform 2 different searches on my database: 1) List all results by locality. I should be able to narrow the search down by entering a title keyword, city, or state. 2) List all titles that match a result string. The match should not have to be exact, but should just look for keyword matches and pull up the closest matches. I should be able to narrow down the search by entering a city, state, or locality. I should be able to specify the following variables: 1) MySQL Server address 2) MySQL username 3) MySQL password 4) MySQL database name 5) MySQL table name 6) Title database Field 7) Locality database Field 8) City database field 9) State database field 10) MerchantID database field 11) Number of search results per page 12) Send-to URL When you click on a result, it should go to a page setup like this: http://send-toURL?merchantid For example, if the send-to url is "[login to view URL]" and the merchant id is "6578" the URL the result would link to would be this: [login to view URL] ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) Code must be commented very well. ## Platform Apache PHP MySQL MSIE Netscape All Web Browers