openside("Ostatnie tematy");

$limit = 10;

$adr = 'Adres Strony/';

$con2 = dbconnect('[color=blue]HOST[/color]', '[color=blue]USER_BAZY[/color]', '[color=blue]HASLO_USERA[/color]', '[color=blue]NAZWA_BAZY[/color]');

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

while ($row = mysql_fetch_array($result))

{

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

echo($row['topic_id']);

echo '\' title=\'';

echo($row['topic_title']);

echo '\' target="_blank">';

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

echo '</a>';

echo '<br>';

}

dbconnect($db_host, $db_user, $db_pass, $db_name);

closeside();