openside("name"); echo "
Najwyżej oceniane:
"; $wynik = dbquery("SELECT *, (SELECT COUNT(rating_id) FROM ".$db_prefix."ratings c WHERE c.rating_type='A' AND (c.rating_item_id = article_id)) AS ile, (SELECT ROUND(AVG(rating_vote), 2) FROM ".$db_prefix."ratings c WHERE c.rating_type='A' AND (c.rating_item_id = article_id)) AS srednia FROM ".$db_prefix."articles ORDER BY srednia DESC, ile DESC LIMIT 4"); echo ""; if(dbrows($wynik) > 0) { while($data = dbarray($wynik)) { echo ""; } } else { echo ""; } echo "
".$data['article_subject']." Oceniono: ".number_format($data['ile'])."
Średnia: ".number_format($data['srednia'], 2)."
Brak artykułów
"; echo "
Najczęściej czytane:
"; $wynik1 = dbquery("SELECT * FROM ".$db_prefix."articles ORDER BY article_reads DESC LIMIT 4"); echo ""; if(dbrows($wynik1) > 0) { while($data1 = dbarray($wynik1)) { echo ""; } } else { echo ""; } echo "
".$data1['article_subject']."Czytano: ".number_format($data1['article_reads'])."
Brak artykułów
"; closeside();