PHP indexing a databse

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
hame22
Forum Contributor
Posts: 214
Joined: Wed May 11, 2005 5:50 am

PHP indexing a databse

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

sounds like you're looking for FULLTEXT indexes. Many databases support this form in one way or another.
Post Reply