Brief description pulled from long description

[Mikey P]

basically i have a description in a mysql table. Is there any way to
pull say like the first 10-20 words for a brief description?

Thanks so much,
Mike

[Dawsons]

if(strlen($late st) >= 20) { $latest = substr($latest[$i][2], 0, 20)."..."; }

Hope this helps
"Mikey P" <ph*********@co mcast.net> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

basically i have a description in a mysql table. Is there any way to
pull say like the first 10-20 words for a brief description?

Thanks so much,
Mike

[d]

"Mikey P" <ph*********@co mcast.net> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

basically i have a description in a mysql table. Is there any way to
pull say like the first 10-20 words for a brief description?
If you want an actual count of words, you can do this:

$brief=join(" ", array_slice(exp lode(" ", $description), 0, 10));

where $description is your long description, and 10 is how many words you
want. Bear in mind usually you'd work out how long your short description
should be on its letter-count, as that's more accurate (though still not
pixel-accurate, obviously).
Thanks so much,
Mike

[Mikey P]

Thanks so much this helped out a lot!

[Marcin Dobrucki]

Mikey P wrote:

basically i have a description in a mysql table. Is there any way to
pull say like the first 10-20 words for a brief description?

Note quite words, but something like that perhaps:

mysql> select substring(your_ description_col ,1,80) from your_table;

which will give you the first 80ish charactrs.

/m