[SOLVED] limiting the amount of text returned from mysql

[adam291086]

Hello

 

I want to create a caption from the text within my database. The text in the database is over 300 character and i want to display around 50. How do i go about doing thi

[revraz]

Just display 50 of the 300 with PHP.

[adam291086]

this is it i dont know how, i have a basic search running on the database and returning the results. How do i limit the words?

[themistral]

Have a look at the substr() PHP function - http://uk2.php.net/substr

 

substr($string, 0, 50);

should work for what you want!

 

It will limit characters not words.

[adam291086]

is there away to add ............ on the end?

[themistral]

echo substr($string, 0, 50) . '...';

 

Just add however many dots you want at the end after the substring.