openside("Download");

echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";

$result = dbquery("SELECT * FROM ".$db_prefix."download_cats ORDER BY download_cat_id");

if (dbrows($result)) {

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

echo "<tr><td width='200' class='tbl1' style='vertical-align:top'><img src='".THEME."images/bullet.gif' alt=''> 

<b><a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat_id']."&sort=1'>".$data['download_cat_name']."</a><b></td><td class='tbl1' style='vertical-align:top'>"; 

$result2 = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='".$data['download_cat_id']."' ORDER BY download_datestamp");

while ($data2 = dbarray($result2)) { 

echo "<img src='".THEME."images/bullet.gif' alt=''> <b>".$data2['download_title']."</b><br><small>- Data dodania ".showdate("%d.%m.%Y %H:%M:%S", $data2['download_datestamp'])."";

echo "<br>- Pobrań ".$data2['download_count']."<br>- Pobierz<br>- 

<a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat_id']."&info_id=5'>Czytaj wiecej</a></small><hr>";

} 

}

}

echo "</td></tr></table>";

closeside();