$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);