Parašė Narysx· 2010 Lap. 15 22:11:37
#175
$a = mysql_query("SELECT avg(rating_vote) as vidurkis, rating_item_id from ".$db_prefix."ratings WHERE rating_type='C' GROUP by rating_item_id order by vidurkis DESC LIMIT 0,10");
while ($q = mysql_fetch_array($a))
{
$vidurkis = $q['vidurkis'];
$idas = $q['raing_item_id'];
echo "Pageo id: $idas | vidurkis: $vidurkis<br>";
}
WHERE rating_type='C'
Tiksliai nežinau, ar ten vadinas rating_type ir ar custom page'ams yra priskiriama raidė C. ;D
Redagavo Narysx· 2010 Lap. 15 22:11:18