Limiting the numbers of characters

[Dzuma]

I have this piece of code to display last ten inputs:

//Start of Last X torrents mod

$sql = "SELECT torrents. * , categories.name AS cat_name, categories.image AS cat_pic
FROM torrents LEFT JOIN categories ON category = categories.id
ORDER BY added DESC LIMIT 10";
$result = mysql_query($sql) or die('No torrents found');
if( mysql_num_rows($result) != 0 )
{
print'<table border=1 cellspacing=0 cellpadding=5 align=right width=95%>';
print'<tr>';
print"<td class=colhead><center>TORRENT</center></td>";
print'<td class=colhead><center>&nbsp;<img src=images/seeders.gif border=0>&nbsp;</center></td>';
print'<td class=colhead><center>&nbsp;<img src=images/leechers.gif border=0>&nbsp;</center></td>';
print'</tr>';

while( $row = mysql_fetch_assoc($result) )
{
print'<tr>';
print'<td class=infobarinner><a href="http://trucker.yuwa.org/details.php?id=' . $row['id'] . '&hit=1">&nbsp;<b>' . $row['name'] . '</b></td>';

print'<td align=center>&nbsp;' . $row['seeders'] . '&nbsp;</td>';
print'<td align=center>&nbsp;' . $row['leechers'] . '&nbsp;</td>';

print'</tr>';
}
print '</table>';
}
else
{
print 'No torrents found';
}
//End of Last X torrents mod

I want to set limit on of characters on the $row['name']. Any help would be very much apreaciated.

[bretticus]

Check out the substr() function. You can do this from MySQL also via the LEFT() function.

[Dzuma]

Hmm, can't figure it out.

[NogDog]

For example, assume you want max characters of 15, then in your echo statement change...

$row['name']

...to...

substr($row['name'], 0, 15);

[Dzuma]

Thanks for the help. Worked like a charm...
Now, I'm wondering if it's possible to make it so when it does go over the max limit to add "..." after.

[Weedpacket]

Yes, it is possible.

If the length of $row['name'] is greater than 15 then you'd use substr($row['name'],0,15).'...' If it's not, you wouldn't.