Последни теми : автор

[human]

Ето един мой скрипт, който си направих за последни теми:

<?PHP
 $our = mysql_query("SELECT forum_id , topic_id,  topic_title  FROM phpbb_topics ORDER BY topic_id  DESC LIMIT 10"); 
 
 while($r=mysql_fetch_array($our)){ 
 if (strlen($r['topic_title'])>34) 
{$totchki='...';} 
else 
{$totchki='';} 
$kratko = substr($r['topic_title'],0,34);
echo "<div id='block_linkstyle'><a href='forum/viewtopic.php?t=".$r['topic_id']."'>  »$kratko".$totchki."</div>"; 
} ?></b></a></td><td align='center' class='forum_threadlist' id='small'><?PHP
 $our = mysql_query("SELECT topic_replies  FROM phpbb_topics ORDER BY topic_id  DESC LIMIT 10"); 
 while($r=mysql_fetch_array($our)){ 
echo "<div id='block_linkstyle'>  ".$r['topic_replies']."</div>"; 
} ?></td><td align='center' class='forum_threadlist' id='small'><?PHP
 $our = mysql_query("SELECT topic_views  FROM phpbb_topics ORDER BY topic_id  DESC LIMIT 10"); 
 while($r=mysql_fetch_array($our)){ 
echo "<div id='block_linkstyle'>".$r['topic_views']."</div>"; 
} ?>

Това беше максимума , защото не видях в таблицата автор :? Някой може ли да ми каже как да го изведа?