Looping through records

postmast

I'm trying to display a series for recordsets from a mysql database but limit the amount of words from one field to be displayed on the page. I have used the following code to limit the words but I have tried using different looping techniques to display the records but I get a Cannot redeclare limit_words() error message.

Could someone tell me hthe correct looping code required.

Thanks

<?php

function limit_words($string, $word_limit)
{
$words = explode(" ",$string);
return implode(" ",array_splice($words,0,$word_limit));
}

$content = $row_Details['Message'];
echo limit_words($content,10);

NogDog

You need to define your function outside of whatever loop you want to use, then just call it within your loop. It might be something like:

function limit_words($string, $word_limit)
{
   $words = explode(" ",$string);
   return implode(" ",array_splice($words,0,$word_limit));
}
// now do your loop:
while($row_Details = mysql_fetch_assoc($query_result))
{
   echo "<p>" . limit_words($row_Details['Message']) . "</p>\n";
}

dagon

you could let mysql do the work for you with SUBSTRING_INDEX

select SUBSTRING_INDEX(body, ' ', 50) as body_sub from ...