Need a small coding help! Thanks

[gifforums]

Hai .. need a small help

I wrote a code to fetch latest threads .. [Its a plugin in VB not PHP file]

Its working perfect ..
I need a small change
Here i want to limit the characters of the title to 30 ..
Help me in that

Here it is


global $db, $vbulletin;


$latest_Threads_order="order by thread.dateline Desc";

$leader_movies_f='18,19,20,21,22,23,49,50,51,52,53 ,54,63,64,65,66,47';
$leader_music_f='24,25,26,27,55,56,57,58,97,98,48' ;

$leader_moviess = $db->query_read("
SELECT thread.threadid,
thread.title AS tht,
thread.postusername,
thread.replycount,
thread.lastposter,
thread.views,
thread.attach,
forum.title AS fot
FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "forum AS forum
WHERE thread.forumid = forum.forumid
AND thread.forumid IN ($leader_movies_f)
$latest_Threads_order
LIMIT 20
");

while ($leader_movies = $db->fetch_array($leader_moviess))

{
$leader_movie.="
<div class='alt1'>
<a href='showthread.php?t=$leader_movies[threadid]'><b>$leader_movies[tht]</b></a><br>
<br>
</div>
";
}

eval('$latestthreadsd = "' . fetch_template('developer-threads') . '";');

[kh99]

I think you could just replace the while loop code with


while ($leader_movies = $db->fetch_array($leader_moviess))
{
$title = substr($leader_movies[tht], 0, 30);
$leader_movie.="
<div class='alt1'>
<a href='showthread.php?t=$leader_movies[threadid]'><b>$title</b></a><br>
<br>
</div> ";
}


or if you want something more fancy you could do something like:


while ($leader_movies = $db->fetch_array($leader_moviess))
{
$title = $leader_movies[tht];
if (strlen($title) > 30)
{
$title = substr($title, 0, 27) . '...';
}
$leader_movie.="
<div class='alt1'>
<a href='showthread.php?t=$leader_movies[threadid]'><b>$title</b></a><br>
<br>
</div> ";
}

[gifforums]

Thanks a ton ... thats awesome ..