Search result preview

[cdmn]

Hi,

quick question, how to do search result preview like google does?

------
[link_to_result_page]
word word.... word word [highlight_keyword] word word...
[Revelance]
------

Of course the page is full-text-search indexed. But i cant really understand how to select just 10 words from the whole indexed site with the found phrase...

Some guidelines would be great!

[henry0]

Look at substring there are a bunch of good examples within the users' comments
substring [us.php.net]

[cdmn]

yeah, but if use substring my algorithm would be smth like:

i get indexed content from db
parse it with php

I found it a bit lacky 'couse indexed content are long texts and if search will return like 20 result, parsing those with php will be like parsing 20 articles...

Maybe there are more suitable solution when im already matching string in query...

[eelixduppy]

You can return a substring using MySQL's string function substr [dev.mysql.com]. This is usually how I do it.

[cdmn]

Can you provide me with some example query? :)

[cdmn]

Ok no prob, found answer at [webmasterworld.com ].
Thanks.