opentable("Newsy na [b]STRONA[/b]");

$result = dbquery("SELECT n.news_id, n.news_subject, n.news_cat, nc.news_cat_image, nc.news_cat_id FROM [b]PREFIKS[/b]_news n INNER JOIN [b]PREFIKS[/b]_news_cats nc ON n.news_cat=nc.news_cat_id ORDER BY news_datestamp LIMIT 0,20");

if (dbrows($result)){

echo "<table width='100%' cellspacing='0' cellpadding='0'>";

while($data = dbarray($result)){

echo "<tr>

<td align='left' valign='middle'><a href='http://[b]ADRES.PL[/b]/news.php?readmore=".$data['news_id']."' target='_blank'>".trimlink($data['news_subject'], 20)."</a></td>

<td align='right'><img src='http://[b]ADRES.PL[/b]/images/news_cats/".$data['news_cat_image']."'></td>

</tr>";

}

echo "</table>";

} else {

echo "<center>Brak Newsów na [b]STRONA[/b]</center>";

}

closetable();