Anonymous
public text v1 · immutable$q = $db->query("SELECT count(voting.to_member) as pcount, members.photo as photo, members.login as login, avg(voting.votes) as votes
FROM members, voting
WHERE members.photo!=''
GROUP BY votes, photo, votes
ORDER BY votes DESC, pcount DESC
LIMIT 15");
$photo = array();
while (list($pcount, $photos, $login, $vote) = mysql_fetch_row($q)){
$photo[] = array(
'pcount' => $pcount,
'photos' => $photos,
'login' => $login,
'vote' => $vote
);
}
$t->assign('photo', $photo);