[SOLVED] Limit Output

[Bricktop]

Hi all,

 

I wonder if someone could tell me how I limit MySQL output? Essentially, I have a script that outputs some "Latest News" text - on my main "News" page I would like this output to be limited to say the first 50 words and then a "Read More" link will be clickable to take the reader to the full story.

 

Just wondered on the syntax required to limit the output to the first x amount of words.

 

Thanks!

[JasonLewis]

function limit_words($str, $limit, $extension=""){
$words = explode(" ", $str, $limit + 1); //We plus 1 because limiting the explode causes the remaining words to be placed in the last key.
array_pop($words);
return implode(" ", $words).$extension;
}

echo limit_words("Hey this will be limited to 5 words!", 5, "... Read More");

[Bricktop]

Thanks matey - I'll give it a go!

[CroNiX]

If you want a more consistent look of all of the entries, I would limit by characters, not words.