$db =& Database::getInstance() ;
$myts =& MyTextSanitizer::getInstance() ;

$result = $db->query( "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_time, t.topic_views, t.topic_replies, t.forum_id, f.forum_name, p.post_id, p.uid, p.subject, p.post_time FROM ".$db->prefix("bb_topics")." t LEFT JOIN ".$db->prefix("bb_forums")." f ON f.forum_id=t.forum_id LEFT JOIN ".$db->prefix("bb_posts")." p ON p.topic_id=t.topic_id ORDER BY p.post_time" ) ;

$lines = '' ;
while( $row = $db->fetchArray($result) ) {
	$subject4disp = $myts->makeTboxData4show( $row['subject'] ) ;
	$post_time4disp = formatTimestamp( $row['post_time'] , 'm' ) ;

	$lines .= '
		<tr>
			<td class="odd">'.$subject4disp.'</td>
			<td class="odd">'.$post_time4disp.'</td>
		</tr>
	' ;
}

echo '
	<table class="outer">
		<tr>
			<th>Subject</th>
			<th>date</th>
		</th>
		'.$lines.'
	</table>
' ;