shorten strings?

[ShoeLace1291]

I have a database query that pulls a member's name out of the table.  How would add "..." to the end of the name if the string is more than 7 characters?  For example, the members would be John Smith, John Doe, Jane Doe.  How would I make it appear like this:

 

Jane Do...

John Sm...

John Do...

[dptr1988]

I don't know how to do this in MySQL but here is how you could do it in PHP

 

<?php

$name = 'Jane Doe';

if (strlen($name) > 7)
{
  $name = substr($name, 0, 7) . '...';
}
?>

 

 

http://us3.php.net/substr

 

http://us3.php.net/manual/en/function.strlen.php