Fix Up Our Search Engine on PHP/MySQL site

this site: [login to view URL] needs some fine tuning on the search engine. It currently checks some but not all of the columns in the table's that it searches, and it only returns records for queries that contain the first word in a field even when the query might match the second word. The file with the search function is attached, search function can be found around line 1055. Coder will build locally, test on a private test server. Coder must be able to produce working results on test server and aid the installation of files on live server (if necessary). Coder must schedule their work to be completed fwith time to debug - our server environment is not the same as your local environment! ## 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). ## Platform Safari, Firefox, Internet Explorer all versions.