PHP Search MYSQL Database

We need PHP code for a new search function on our website. We have a database called '1', username is 'username', password is 'password' There is a table in the database called 'properties', within this table there are 49 fields, the fields we are interested in are called 'pid', 'description' and 'pname' We need a search function so a user can enter a search term into a textbox, and the php returns the 'pid' and 'pname' values for positive matches until we have 20 results. A match needs to be determined in the following order. 1. Exact matches first 2. Similar 'Like' matches next 3. If there are two or more words, the longest word should then be checked on its own. 4. If there are still less than 20 results, the next shortest should be checked etc. The results should be shown in a table with the PID in the first (left) table box, and the PNAME in the second (right) table box. ## 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 Web