MySQL queries on MULTIPLE tables of the same database

PHP SCRIPTS TO SEARCH MYSQL TABLES AND CREATE PAGES OF WEB SITE 1. Rewrite php scripts to search multiple mysql tables from the users' queries 2. Rewrite URLs [login to view URL] to [login to view URL] 3. Display results of the users' queries with metatags Similar to http:// mysql php code .com Access to web host provided and database provided. Pleare READ CAREFULLY the specs before bidding. The specs attached are complete and sufficient. For clarity, I will not IM about this project. === CURRENT SCRIPTS AND DATABASE - [login to view URL], as is - [login to view URL] (to be written) - [login to view URL] (to be rewriten) - [login to view URL] (new html and css to wrap it) - [login to view URL] (to be rewritten, html, css) - table A, table B and table C with common fields field1, field2, etc === CURRENT PROCESS [login to view URL] takes a query from [login to view URL] searches in single table of a database [login to view URL] displays the matched results === SCRIPTS AND PROCESS TO DELIVER [login to view URL] sets values for variables [login to view URL] takes a query from [login to view URL] searches in multiple tales of a database [login to view URL] displays the matched results from different tables in the same database and the html metatags (title, description) are the query and the first result