I'm working on a project for a client who wants the search to search multiple tables in the database. There are tables for products, categories, a photo gallery, and basic site pages. I will also be adding tables for shopping cart functionality (customers, orders, etc) that probably shouldn't be searched for security reasons. Per the client, the current search function and advanced search seem "too complicated" for shoppers/site visitors wanting to locate information on specific products/features. Is there any easy script that can be inserted/included to perform this kind of a search (search all records/fields in multiple, specified database tables)? Any help on this issue would be greatly appreciated.
FYI: I'm using PHPRunner 4.0 (waiting for upgrade key on 4.1);
Apache version 1.3.37 (Unix)
PHP version 4.4.4
MySQL version 4.1.22-standard
Thanks,
Janet
