Each day of paid admission makes you eligible to win door prizes,
which we draw at random throughout Wolfcon.
//$conid = $_REQUEST["conid"]; Already have conid!
$sqlsum = "SELECT ConID, SUM(`Qty` * `Value`) as Sm FROM `Prizes` where ConID = ".$conid." group by ConID";//.$conid;
$rsum = mysql_query($sqlsum);
$srow = mysql_fetch_array($rsum);
echo "Over $".round($srow["Sm"])." in prizes, and growing!!! ";
?>
//========================;
$gquery = "Select * from Prizes where ConID = ".$conid." order by Sponser, Prize";
$gresults = mysql_query($gquery);
$Sponser = "";
while ($grow = mysql_fetch_array($gresults))
{ if (trim($grow["Sponser"]) <> $Sponser ) {
echo "| ".$grow["Sponser"]." | | ";
$Sponser = trim($grow["Sponser"]);
}
echo " | | ".$grow["Prize"]." | $".$grow["Value"];
echo " ea | x".$grow["Qty"]."= $".($grow["Qty"] * $grow["Value"])." | ";
}?>
|