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"; ?> |
|
|
