$limit = 10;

$result = dbquery("SELECT thread_id, thread_subject, thread_lastpost FROM fusion_threads ORDER BY thread_id DESC LIMIT $limit");

while ($row = mysql_fetch_array($result))

{

echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td aling=\"left\">\n";

echo '<img src="'.THEME.'images/bullet.gif" alt="cms"> <a href=\''.BASEDIR.'forum/viewthread.php?thread_id=';

echo($row['thread_id']);

echo "' title=\'\n";

echo($row['thread_subject']);

echo '\'>';

echo(substr($row['thread_subject'],0,20));

echo "</a>\n";

$wynik = dbquery("SELECT notify_datestamp FROM fusion_thread_notify GROUP BY notify_datestamp ORDER BY notify_datestamp LIMIT 0,30");

$data = dbarray($wynik);

echo "</td><td align=\"right\">".showdate("shortdate",$data['notify_datestamp'])."</td></tr></table>\n";

}