Limit displayed info...

leinj

I have absolutely no idea how to do this, so it's possible it has nothing to do with MySQL at all, but I've got to give it a try... 🙂

I have a PHP/MySQL site that displays a bunch of articles. I need to show a limited amount of the "articleBODY" field as a sort of summary of the article when a list of the articles is shown.

So you'll see:

ARTICLE NAME: Author
A limited amount of info because all of it... [read more]

Very common practice all over the web, but can't find any help on how to do it. See evolt.org for example if you need further clarification: http://evolt.org/category/all/17/121/10/index.html

Thanks!

LordShryku

[man]substr[/man]

leinj

Thank you very much!

And for anyone else who stumbles upon this post - the following code works great(grabbed from php.net):

How to make a nice trim of text without break words in the middle :

$maxTextLenght=125;
$aspace=" ";
if(strlen($text) > $maxTextLenght ) {
$text = substr(trim($text),0,$maxTextLenght);
$text = substr($text,0,strlen($text)-strpos(strrev($text),$aspace));
$text = $text.'...';
}

And modified to work with my database ($myrow[""] grabbed from database):

$text = $myrow["articleBODY"];
$maxTextLenght=50;
$aspace=" ";
if(strlen($myrow["articleBODY"]) > $maxTextLenght ) {
$text = substr(trim($myrow["articleBODY"]),0,$maxTextLenght);
$text = substr($text,0,strlen($text)-strpos(strrev($text),$aspace));
$text = $text.'...';
}

Thanks again! 🙂