$data = "select count(voting.id) as total, to_member, avg(voting.votes) as votes, members.photo from voting, members group by voting.to_member order by voting.votes DESC limit 100"; $result = mysql_query($data) or die (mysql_error()); $num= 1; $nums = array(); $names = array(); $israte = array(); $isphoto = array(); while($ratings = mysql_fetch_assoc($result)) { $vrate =$ratings['votes']; $namevote =$ratings['to_member']; $total =$ratings['total']; $photos =$ratings['photo']; $nums[] =$num; $names[] =$namevote; $israte[] =$vrate; $isphoto[] =$photos; $num++; } var_dump( $ratings ); echo "lolo: ".$photos;