Great

mizzy — Fri, 02 May 2003 23:56:01 +0000

Thanks ...works perfectly

Mark Hensler — Fri, 02 May 2003 11:09:56 +0000

I would very much recommend the first solution (SQL) over the second (PHP). This will occupy less memory, and may be a bit faster once the recordset is returned to PHP for further processing.

ROB — Fri, 02 May 2003 03:29:04 +0000

or if you want a php function i use something like this

<?php
function strshorten($instr,$len) {
    $instr = trim($instr);
    if(strlen($instr) > $len) $instr = substr($instr, 0, $len) . '...';
    return $instr;
}

$string = 'this string has 29 characters';
echo strshorten($string, 16);
// prints 'this string has...'
?>

ROB — Fri, 02 May 2003 03:22:03 +0000

this should work

SELECT CONCAT(SUBSTRING(fieldname, 0, 100), '...') AS fieldname FROM tablename;