Say i have a variable $descripton which has been selected from MySQL.. How would I set it so it displays only the first 50 or so characters and then '...' on the end

So it just displays a brief description..Like on this forum

Eg

This is just a brief description describing...

Thanks

-James

Afaik, you can do it two ways.

You can use MySQL to limit the number of characters that is returned by using:

SELECT LEF(columnname,50) FROM tablename...

Or you can use PHP to only display the first 50 characters by using:

PHP Code:

echo substr($description, 0,50); 


Thanks

-James