Limiting Characters displayed from Variable

[ow-phil]

Hi all,

I am working on a script for displaying historical Information from a database(mySQL) and have a quick question. In the admin section for the script, I have a page which displays a list of what is in the table. Right now it displays "AutoID", "Date", "Category", "Activestatus". What I want to do, is to display the fifth variable, which is "Description". But the description would be long, so what I want is to have it so it displays the first 100 characters of the variable, so the admin person would have a hint of what is in that field. Any ideas?

Many thanks... Phil

[chrima]

Hi there,
try something like:

<? $str=$row['Description']; $max=100; $modstr=((strlen($str)>$max)?substr($str,0,$max)."":$str);?><? echo $modstr?>

Cheers,
chrima

[cgraz]

PHP has a built in function for this. substr(). Makes things much easier.

Cgraz

[briansol]

i use something like this after the sql selection....

$m = mysql_fetch_array($result)
$j = stripslashes($m[description]);
$k = substr($j, 0, 70); //limits to 70 char's

echo $k;