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



if (dbrows($most_recent_downloads)) {



// Only display articles that exist

while($download = dbarray($most_recent_downloads)) { 



 if ( $x <= $num_downloads ) {

  // Calculate date submitted

  $download['download_datestamp'] = showdate("shortdate", $download['download_datestamp']);

  

  // Look up Category

  $result = dbquery("SELECT * FROM ".DB_DOWNLOAD_CATS." WHERE download_cat_id='".$download['download_cat']."'");

  $category = dbresult($result,0);



  // Look up Author

  $result = dbquery("SELECT user_name FROM ".DB_USERS." WHERE user_id='".$download['download_user']."'");

  $a_author = dbresult($result,0);

  

  $srednia = dbresult(dbquery("

SELECT ROUND(AVG((SELECT AVG(rating_vote) FROM ".DB_RATINGS." WHERE (rating_item_id=download_id) AND rating_type='D')), 2) AS srednia

FROM ".DB_DOWNLOADS.""),0);



  // Display articles

  echo display_downloads($download,$category,$a_author,$srednia);

  $x++;

 }

}

} else {

echo "<tr><td colspan='5' align='center'><p>Brak</p></td></tr>";  

}



echo "</table>";