How to have a limit for character viwing in a recordset

[pantinosm]

Hi everyone. I am new to php so i be patient. I have a mysql db and i use a recordset to manipulate it.
I have a table in html and i try to fill it with data. The problem is that a field is a url link with no spaces that causes my page to break.
So i need somehow to show only the start of the link and then ... like yahoo lets say.
My problem can be seen here
[url=http://www.ibeba.com/world/worldsearch.php?txtsearch=art&Submit=Search+Her]http://www.ibeba.com/world/worldsearch.php?txtsearch=art&Submit=Search+Her[/url]

Thank you in advance.

[taith]

[code]
$text= "reallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreally long word";
wordwrap($text, 20, "<br />\n");
[/code]

[taith]

i also wrote this pretty little function
[code]
<?
function filter_charlimit($string, $length="50"){
if(strlen($string)<$length) return $string;
else return trim(substr($string, 0, $length)).'...';
}
?>
[/code]

[pantinosm]

Thank you so much. That works great.