[UPHPU] automatic calculation procedure?

[Brandon Stout]

Connor Boyack wrote:
> Does MySQL have something that lets you do this type of thing, or do 
> you have to run a cron job on a php file that has the calculations?
Connor,

I'm just catching up on my emails, and although it's over a week and a 
half later, thought I'd add a bit here.  Rather than writing your own 
flag algorithms, you can let MySQL do the work for you.  Make a table of 
keywords, then search for those keywords in a fulltext field that 
captures the information you want to score.  MySQL's FULLTEXT index 
automatically scores the information for you if you do a normal fulltext 
query.  I've used this feature to successfully search and prioritize rss 
feed articles.  Read about it here:

MySQL 5:  http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
MySQL 4.x:  http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html

Brandon Stout
http://mscis.org