I have a need for a collection of scripts. Each script is similar. The only difference is the number of fields. All would be exported from MS Access 2003 or 2007. Each database has between 4 and 25 fields. There would be up to 25,000 total records (200,000 total fields filled). Any updates in the future would use the same fields mapped and be exported fully from access. Some fields contain HTML.
The scripts I need are a series of single scripts to search one database. I would need one for each database (currently 10). They need to do the following:
1. Have a search capability and display capability in a PHP block, so pagination might be needed. These would be displayed in a vBPortal block cleanly.
2. Have the first three categories come out highlighted for single click seach of that word or phrase in the top three categories.
3. Have full text searching.
4. Utilize mysql.
5. Display cleanly.
And that is really about it.