Only show so many characters

[jmweb]

I have a mysql database setup to track refferals to my site. In my mysql database I have a field called "refer" which tracks where people are coming from. When I setup a page that shows the refferals it shows the complete url in long version. An example is at http://www.johnboymorris.com/refer/test.php
If you notice a couple long urls, for instance "http://www.aolsearch.aol.com/aol/search?encquery=142503c39ee67e031f51b093bda123b5f6a68b9c55114802&invocationtype=keyword_rollover&ie=iso-8859-1" they are rather annoying. Instead I would like the table of refferals to display
http://www.aolsearch.aol.com/.../ie=iso-8859-1 however link to

"http://www.aolsearch.aol.com/aol/search?encquery=142503c39ee67e031f51b093bda123b5f6a68b9c55114802&invocationtype=keyword_rollover&ie=iso-8859-1"

Anyone know how to do this?

[Pig]

When displaying the links on the page, use strlen() to get the size. If it is over a certain length, then echo the link, but for the part that's inbetweent he <a></a> tages, use substr() to get the first 40 characters of the string, put a ..., and then use substr to get the last few characters of the string.

[jmweb]

ya thanks, i got it taken care of, just took some time...