openside("Najnowsze tematy");

$limit = 10;

$result = dbquery("SELECT topic_id, topic_title FROM phpbb_topics ORDER BY topic_id DESC LIMIT $limit");

while ($row = mysql_fetch_array($result))

{

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

echo($row['topic_id']);

echo '\' title=\'';

echo($row['topic_title']);

echo '\'>';

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

echo '</a>';

echo '<br>';

}

openside("Najciekawszwe tamaty");

$limit = 2;

$result = dbquery("SELECT topic_id, topic_title, last_poster_id FROM phpbb_topics ORDER BY last_poster_id DESC LIMIT $limit");

while ($row = mysql_fetch_array($result))

{

echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href=\'forum/viewtopic.php?t=';

echo($row['topic_id']);

echo '\' title=\'';

echo($row['topic_title']);

echo '\'>';

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

echo '</a>';

echo '<br>';

}

closeside();