Page 1 of 1

PHP indexing a databse

Posted: Wed Nov 29, 2006 10:43 am
by hame22
Hi

I have a database table containing records of news articles. Each record has a field for headline, summary and body.

I am looking for an indexing system that indexes this data and returns results based upon a users keyword search criteria.

I would like to give different scores depending on where the keyword is found, e.g. if the keyword is found in the headline score it greater than when it is found in the body.

I wondered if there was any open source project that could achieve these requirements??

Thanks in advance

Posted: Wed Nov 29, 2006 2:05 pm
by feyd
sounds like you're looking for FULLTEXT indexes. Many databases support this form in one way or another.