displaying PHP search results of a MySQL database a la google

[misha]

Hi,

I'm wondering how I can display the results of a multi-keyword search of article text in a MySQL databse so that only partial article text (perhaps 5 words on either side of the keyword) is displayed instead of the entire article text column. This is how google.com does it (bolds the keyword and shows text to either side of the keyword).

I'm using explode to create an array of the keywords, but I could use fulltext if that helps.

I am a total PHP and MySQL newbie, but I was wondering if there's some function that does this, or a good tutorial on how to do it.

Thanks for the help,
Misha

[leatherback]

Hi,

Hm.. I suppose you could use srtpos to get the position of the keyword string in your txt, insert a string there by chopping the string at that place, and using substr to get the substring around the keyword?

J.