Displaying Entry Partially

bigmac

I am trying to display a small part of a field from a table. Basically, it's a long story, but I want to show only the first few sentences of it and not the whole thing. Is there any way to do it? Is there multiple ways maybe?

Thanks.

mattuu

You didn't specify your database, but if it were, say, MySQL, you could do:

SELECT LEFT(text,50) from stories;

That would give you the first 50 characters of the text fields in the stories table.

Rayn

This is the PHP way of doing that...and this varible per say is the variable that contains the store: $story

This would count the number of charecters in the store and cut it in 1/4th

$story_total=strlen($story);
$story_total=round($story_total/4);

so if we had 200.. it would then equal 50.

Now this takes away part of the story.

substr($story, 0, $story_total);

This would only show the first 50 chars of the store... put it all together and this is what you have.

$story_total=strlen($story);
$story_total=round($story_total/4);

$short_story=substr($story, 0, $story_total);

Hope this helps.
- Dan