Beer Belly Blobs

[JakesSA]

I've got about 40 rows of large amounts of text stored as blobs in my db. What I'm trying to achieve is that, when a visitor searches the blobs, it will only bring up the first 4 or 5 lines of the article and then have a read more link to the rest . Does anyone have a similar PHP script that I can take a look at, to help me with this?
🙂

[raymie]

don'y have a script to hand for that but since noone else has replied.....

Perhaps you should take the data, run it through explode to split it into sentences (using /n as a delimitter perhaps) and then print out the first few items of the resultant array.

[destop]

you could always use the substr() function

like this

$string = [blob];
$sub = substr("$string", "0", "50");
echo $sub;

this would print the first 50 char of the blob, i would suggest that you also follow the prev suggestion because you would not want half a word being printed...