If you need to display the latest shout..use this code:
ÂÂ
global $settings;
$tp_prefix = $settings['tp_prefix'];
ÂÂ
 $request = db_query("SELECT * FROM {$tp_prefix}shoutbox WHERE type='shoutbox' ORDER BY value2 DESC LIMIT 1", __FILE__, __LINE__);
if (mysql_num_rows($request) > 0)
{
 $shouts='';
 while($row = mysql_fetch_assoc($request)){
 $shouts .= doUBBC($row['value1'],true);
 $shouts .='<br /> by <b>'.$row['value3'].'</b> on '.timeformat($row['value2']).'<br />';
 }
 echo $shouts;
 mysql_free_result($request);
}
It will also allow more than 1 shout, simply change the "limit 1" to you preferred number ("limit 5" for example), and maybe add some limiters to the html code.
--edited 29/3/07---
Edited code to reflect the table that was renamed in TP 0.9.8