$ile_na_strone = 10;

$rows = dbcount("(download_id)", DB_DOWNLOADS."");

if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }



$wynik = dbquery("SELECT download_id, download_cat, download_title, 

download_cat_id, download_cat_name

FROM ".DB_DOWNLOADS." 

LEFT JOIN ".DB_DOWNLOAD_CATS." ON (download_cat=download_cat_id)

ORDER BY download_datestamp DESC LIMIT ".$_GET['rowstart'].", ".$ile_na_strone."");

if(dbrows($wynik) > 0) {      

while($r = dbarray($wynik))    

{

echo "<span class='small2' style='display: block'>".THEME_BULLET." <a href='".BASEDIR."downloads.php?cat_id=".$r['download_cat']."&download_id=".$r['download_id']."'>".$r['download_title']."</a> Kategoria <a href='".BASEDIR."downloads.php?cat_id=".$r['download_cat_id']."&sort=1'>".$r['download_cat_name']."</a></span>";  

}

} else {

echo "<span style='text-align:center'>Brak plików w bazie.</span>";  

} 

if ($rows > $ile_na_strone) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'],$ile_na_strone,$rows,3)."\n</div>\n";