Below are the most recent SLBS contest results ~ Click on the Contest to see Contest Details
Date | Contest ( click results) | Grand Champion | Reserve Grand Champion |
query($sql) as $row){
$contestid = $row['contestid'];
$contest_name = stripslashes($row['contestname']);
$contest_sanctioningbody = $row['sanctioningbody'];
$contest_citystate = $row['citystate'];
$contest_conteststartdate = date("m-d-Y", strtotime($row['conteststartdate']));$sql = "SELECT contestresults.teamname, contestresults.place, contestresults.score
FROM contestresults
WHERE contestid = $contestid
AND category = 'Overall'
AND contestresults.place = 1";
foreach ($dbh->query($sql) as $row){
"GC :".$gc = stripslashes($row['teamname']);
}
$sql = "SELECT contestresults.teamname, contestresults.place, contestresults.score
FROM contestresults
WHERE contestid = $contestid
AND category = 'Overall'
AND contestresults.place = 2";
foreach ($dbh->query($sql) as $row){
"RGC: ".$rgc = stripslashes($row['teamname']);
}
?> | $contest_name"; ?> | | |
