Search Logic

Greetings everyone, We are looking for advice on what is the best way to search text in database tables from a webpage. We will have roughly fifty web pages which will execute searches. We have outlined the basic parameters how the searches will function on a webpage and this can be seen in Search Functionality 1.0 doc. The types of searches will be used quite frequently combined together or possibly individually depending on the webpage. Some of the questions we have are: What is the most efficient way to search the database tables? Should we use full text searching? I have read about full text searching for MySql but this appears to only works for MISam tables, and all of our tables are currently Innodb. Would using SQL “LIKE?? comparison for all field that are require be an efficient possibility Do you have any suggestions on how to create a standard search algorithm based on the Search Functionality 1.0. doc? The end result of this bid we like to have a detailed word document -Answering the questions above -Explaining the best method for searching database tables from web pages according to Search Functionality 1.0.doc. This bid is not for one person, we are hoping to hear a wide range of feedback and in result will accept all bidders who have put a full effort response. Other variables The current platforms is: PHP ??" 5.0 MySql ??" 4.0.20 Apache Server ??" 1.3.27 Linux ??" 7.3 Database Tables that will require searching will grow eventually to the level of one million records Best Regards, Wade Willett Schools Without Limits (a nonprofit organization) ## Deliverables 1) Detailed word document 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 PHP ??" 5.0 MySql ??" 4.0.20 Apache Server ??" 1.3.27 Linux ??" 7.3