How to trim data , data retrived from mysql

[Butterfly Wing]

Hellow,
The script is not working.. I am retriving data from MySql database into table.. the width of the table is 281 so small so i wanted to cut the text say eg. : Today Mr. X-Men is visiting Thimphu for his lates show off movie traillers. I wanted to trim it in this formate : Today Mr. X-Men is visiting Thimphu for ... The rest of the data i can hyperlink this sentence and show it in the another page.. Just like the Yahoo News for ur kind information.

[edited by: coopster at 1:16 pm (utc) on Jan. 6, 2005]
[edit reason] snipped unnecssary code [/edit]

[coopster]

A search of the forum brought up a couple of relative threads:

Select a number of words from a string in mysql [webmasterworld.com]
syntax for selecting first 100 characters from a mysql field [webmasterworld.com]

In your link you could just reference the key for the relative row of the table.