You just described my procedure! I do exacly that, plus, I also save a soundex or metaphone code for each word so I can check spelling and closest matches.
Cesar.
Curt Zirzow wrote:
Instead of just adding a word to table of words, you add a field that holds the qty of times it appears in the document. So now the sql looks something like:
select qty, docid from keywords where word='people' order by qty
With an index on qty, the query should be rather fast. And now you can join the keyword table and the main document table together so you can display the results:
select k.qty, doc.* from keywords k, documents doc where k.docid = doc.id k.word='people' order by k.qty
I do this very exact thing for my graphs and reports listed below.
Curt
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php