$q = $db->query("SELECT members.photo as photo, members.login as login, avg(voting.votes) as votes FROM members, voting WHERE members.photo!='' GROUP BY members.photo ORDER BY votes DESC LIMIT 2"); $photo = array(); while (list($photos, $vote) = mysql_fetch_row($q)){ $photo[] = array( 'photos' => $photos, 'vote' => $vote ); } print_r ($photo);