';
echo '
';
echo '| Topic | ';
echo 'Topic starter | ';
echo 'Last Post By | ';
echo '
';
$result = mysql_query("SELECT * FROM `topics` ORDER BY `lastpost` DESC");
$last_post = mysql_query("SELECT `last_post_alias` FROM `topics`");
$last_post_alias = mysql_fetch_array($last_post);
while($row = mysql_fetch_array($result)){
?>
|
=$row['title'];?>
|
=$row['alias'];?>
|
if(mysql_num_rows($last_post)>=1){ echo $last_post_alias['last_post_alias']; }else{ echo 'No comments yet'; }?>
|
}
echo '';
?>