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

PHP Code:

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

PHP Code:

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:

PHP Code:

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 ..