Date: 11/16/07 (PHP Community)    Keywords: php, mysql, html, sql, web

Hello Friends

I want to add a search functionality to a project I am working on. I'd like the search function to index text held in several MySQL tables and then generate a list of keywords to be stored in another table. I do not want a web crawler or an indexing function that indexes files on the filesystem.

The search function will then access this table of keywords in order to find matching documents, and hopefully return them in order of relevance.

I know of this project: http://www.phpguru.org/static/PorterStemmer.html However, it is PHP5 only. The PHP4 project it borrows from, http://www.chuggnutt.com/stemmer.php may or may not work, but it seems to perhaps be buggy.

Anyone have any recommendations for such a project?

Thanks!

Source: http://community.livejournal.com/php/596534.html