Hey,
Does anyone know how I can limit the description field on this query to just display 20 characters. I've tried some of the ideas I've seen mentioned such as using substr but it doesn't seem to work for this criteria. Here is the script. If anyone has any ideas what might be the best way to do it I would be really grateful.

PHP Code:
$query  "SELECT Product_ID, Genus, Common_name, Description FROM products ORDER BY Product_ID DESC";
$result mysql_query($query) or die('Error, query failed');
$numofrows mysql_num_rows($result);

for(
$i 0$i $numofrows$i++) {
    
$row mysql_fetch_array($result); 
    if(
$i 2) { 
        echo 
"<tr bgcolor='lightgrey'>";
    } else { 
        echo 
"<tr bgcolor='white'>";
    }
    echo 
"<td>".$row['Product_ID']."</td><td>".$row['Genus']."</td><td>".$row['Common_name']."</td><td>".$row['Description']."</td>";
    echo 
"</tr>";

Thanks
Russ