help on printing a text

[nakkaya]

i have a long desc of each page in my database and i need to geting the desc of each page
and print the 250 letters after the keyword i spent 3 hours to modify this code but i couldn't thx for the help
as an example:

desc of page is like

this page is about a greate os named linux and lets say this is a long long long desc like 3 pages.

when linux is searched i need to return 250 char after linux including linux how is it possible searching is not a problem only problem is printing.

thx for help

[Nick_Whymark]

You should be able to select them using something along the lines of (apologies if the syntax is a bit out):

SELECT SUBSTRING('description', INSTR('description','Linux'), 255)
FROM desc_table
WHERE mykey IN
(SELECT mykey FROM desc_table WHERE MATCH (description) AGAINST ('Linux');

I'm not sure if all (or any) versions of mysql support subqueries, but if not you could do the search subquery first and then loop around the result set applying SUBSTRING query.

An alternative would be to return the description field and use PHP to return the substring:

Assume your 3 pages are returned in $description:

$Searchstring = "Linux";
$SmallString = substr($description, strpos($description, $Searchstring), 250);

Hope I understood the question !
Nick