$field < $objectarray[$b]->$field; else $bool = strcasecmp($objectarray[$a]->$field, $objectarray[$b]->$field) < 0; if ($r) $bool = !$bool; if ($bool) { $temp = $objectarray[$a]; $objectarray[$a] = $objectarray[$b]; $objectarray[$b] = $temp; } } } return $objectarray; } foreach ($_REQUEST as $key => $value) $$key = $value; //access database require("accessdb.inc.php"); $sql = mysql_query("SELECT count(winner) as announced FROM winners WHERE winner != '0'",$db); $count = mysql_result($sql, 0, "announced"); if ( !isset($s) ) { $s = "points"; $r=1; } if ($r == 1) $sort = "dn"; else $sort = "up"; ?>

home · entry statistics

refresh

Comments on bottom of page!

NUMBER OF OSCAR WINNERS ANNOUNCED: /24

nick = mysql_result($sql, $i, "nickname"); $entries[$i]->location = mysql_result($sql, $i, "location"); $entries[$i]->points = 0; $entries[$i]->tiebreaker = mysql_result($sql, $i, "tiebreaker");; $entries[$i]->method = strtolower( mysql_result($sql, $i, "method") ); for($j=1;$j<=24;$j++) { if ( mysql_result($sql2, $j-1, "winner") == mysql_result($sql, $i, "cat$j") ) $entries[$i]->points += mysql_result($sql2, $j-1, "points"); } } $entries = sort_by_field($entries, "points", 1); $entries[0]->rank = 1; for ($k=1; $kpoints == $entries[$k-1]->points ) $entries[$k]->rank = $entries[$k-1]->rank; else $entries[$k]->rank = $k + 1; } $entries = sort_by_field($entries, $s, $r); $high=0; for($i=0;$i<$rows;$i++) { if ($entries[$i]->points > $high) $high=$entries[$i]->points; } for($i=0;$i<$rows;$i++) { if ($entries[$i]->points == $high) { $bold=""; $boldoff=""; } else { $bold=""; $boldoff=""; } echo ""; } ?>
rank"; ?> nickname"; ?> location"; ?> score"; ?> tie breaker"; ?> method"; ?>
{$entries[$i]->rank}$bold{$entries[$i]->nick}$boldoff{$entries[$i]->location}$bold{$entries[$i]->points}$boldoff$bold{$entries[$i]->tiebreaker}$boldoffmethod}.gif\" width=\"16\" height=\"16\" alt=\"{$entries[$i]->method}\" border=\"1\">