Shorten a long string to .

[natural number]

I'm outputting a large amount of data from mysql and I want to shorten it.

I want to change this display "Once upon a midnight dreary, while I pondered weak and weary. "

to something like this "Once upon a midnight ..."

Any ideas guys? I bet I'll get a fix in 10 minutes.

[coopster]

You have a couple of options, you can truncate the data in your SQL statement or you can substring it after it comes out using PHP.

Here are some examples with options ...

How to avoid words being chopped with SUBSTR [webmasterworld.com]
Which string() to use to display first 500 words of data [webmasterworld.com]
syntax for selecting first 100 characters from a mysql field [webmasterworld.com]

[natural number]

wow coopster, that was fast! thanks.