");
unset($winner,$winning_person,$find_winner);
}
}
// Build Winner Titles Across Top
$query = ("
SELECT
*
FROM grid_titles
WHERE order_top IS NOT NULL AND gid = $gid
ORDER BY order_top
");
$result = db::Q()->prepare($query);
$result->bindParam(":id", $id);
$result->bindParam(":org", $org);
$result->execute();
$gridtop .= "
";
while ($x = $result->fetch(PDO::FETCH_OBJ)){
$gridtop .= "
W$x->title
";
}
// Build Primary Grid
$query = ("
SELECT
*
FROM grid
WHERE gid = $gid
ORDER BY spot
");
$result = db::Q()->prepare($query);
$result->execute();
$row = 0;
$column = 0;
while ($x = $result->fetch(PDO::FETCH_OBJ)){
$count++;
// What is the value of this square
$yquery = "SELECT * FROM grid_titles WHERE order_top = $column AND gid = $gid LIMIT 1";
$yresult = db::Q()->prepare($yquery);
$yresult->execute();
if ($y = $yresult->fetch(PDO::FETCH_OBJ)){
$number_one = $y->title;
}
$yquery = "SELECT * FROM grid_titles WHERE order_side = $row AND gid = $gid LIMIT 1";
$yresult = db::Q()->prepare($yquery);
$yresult->execute();
if ($y = $yresult->fetch(PDO::FETCH_OBJ)){
$number_two = $y->title;
}
$number = $number_one . $number_two;
if ($count == 1){
// Get left titles
$yquery = "SELECT * FROM grid_titles WHERE order_side = $row AND gid = $gid LIMIT 1";
$yresult = db::Q()->prepare($yquery);
$yresult->execute();
if ($y = $yresult->fetch(PDO::FETCH_OBJ)){
$grid .= "
L$y->title
";
}
}
// Classes
// if ($x->)
// Win
if (array_key_exists($number, $winningscore)){
$win = $winningscore[$number];
$win_display = "
$$win
";
$win_wrap = "winner";
$totals[$x->name] = $totals[$x->name] + $win;
}
// Fill the inside of the div
if ($x->name && !$x->paid){
$x->inside = "Hold: $x->name";
}
else if ($x->name){
$x->inside = "$x->name";
}
else {
$x->inside = "Request";
}
$grid .= ("