Get first 5 words from database record

[argrafic]

Hello,

 

I want to display the records from a table in the database but i don't want all the info printed on screen because there are columns that have long text, so I wanted to know how can I get the first 5-10 words from the column and print those on screen?

 

Thanks!

[dezkit]

i think this is what you mean...?

 

SELECT * FROM example ORDER BY id DESC LIMIT 5

[DarkWater]

$words = explode(" ", $string);

for ($i=0; $i<5; $i++) {

 $output .= $word[$i];

}

$output .= "...";  //Add a ... to the end of it to signify more content.

echo $output;

 

=) Just put in the correct $string variable.

[dezkit]

wow, i really never pay attention to threads...

[DarkWater]

I was going to quote your post and ask what the hell you were doing, but I decided that it wouldn't be nice. =P

[argrafic]

Excellent!!! Thanks DarkWater!!!!