Stuff

function GetVoteArray(&$VoteArray)
{
	$command1 = "SELECT DISTINCT photo,member,category FROM photo_vote";
	$result1 = mysql_db_query("db_member_info",$command1);
	
	if($result1!= FALSE)
	{
	
		while($array1 = mysql_fetch_array($result1))
		{
			$photo_tmp[$counter] = $array1['photo'];
			$member_tmp[$counter] = $array1['member'];
			$category_tmp[$counter] =$array1['category'];
			$command2 = "SELECT photo,member,category, AVG(vote),COUNT(vote) FROM photo_vote
				WHERE photo='$photo_tmp[$counter]' AND member='$member_tmp[$counter]' AND category='$category_tmp[$counter]' GROUP BY photo,member,category";
				
			$result2 = mysql_db_query("db_member_info",$command2);
			if($result2!= FALSE)
			{
				while($array2 = mysql_fetch_array($result2))
				{
					$VoteArray[] = array('photo' => $array2['photo'],
										'member' => $array2['member'],
										'category' => $array2['category'],
										'avg_vote' => $array2['AVG(vote)'],
										'vote_nr'  => $array2['COUNT(vote)']);
				}
			}
			else
			{
				exit ("Incorrect query " . mysql_error());
			}
		}
	}
	else
	{
		exit ("Incorrect query " . mysql_error());
	}
}