view only first x words..?

[supermars]

Hi all, I'm wondering how can I output only the first x words from a field..
By this I mean that I've done SELECT * FROM table; got the row that I care about selected and then in that row I need to output everything normally and just one field I'd like it to display only the first 20 words or 80 characters...
How do you do that? :bemused:

Thanks!

[chrille112]

Hi!

Try this:

$string = "Habbla habbla php rocks";
$NUM_WORDS = 2;

$tmp = explode(' ', $string);
for($i=0; $i<$NUM_WORDS; $i++)
echo $tmp[$i].' ';

[supermars]

chrille112 wrote:

Hi!

Try this:

$string = "Habbla habbla php rocks";
$NUM_WORDS = 2;

$tmp = explode(' ', $string);
for($i=0; $i<$NUM_WORDS; $i++)
echo $tmp[$i].' ';

works good! actually I also tried with

substr("$row[field_name]", 0, 200)

which has
pros : no error if field has less than 200 characters
cons : works on characters, so it displays only some characters of the last word..
So I'm using yours! 😃
Thanks!