2018 competition schedule
City |
Competition Date |
Deadline |
Early Bird |
Location |
mysql_connect($server,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query=" SELECT * FROM tb_locations ORDER BY LocationID ";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$IsClosedCode = "";
$i=0;
while ($i < $num) {
$LocationID = mysql_result($result,$i,"LocationID");
$LocationName = mysql_result($result,$i,"CityName") . ", " . mysql_result($result,$i,"StateName");
$CompetitionDate = mysql_result($result,$i,"CompetitionDate");
$DeadlineDate = mysql_result($result,$i,"DeadlineDate");
$RebateDate = mysql_result($result,$i,"RebateDate");
$ScheduleLink = mysql_result($result,$i,"ScheduleLink");
$IsClosed = mysql_result($result,$i,"IsClosed");
$PlaceName = mysql_result($result,$i,"PlaceName");
$PlaceAddress = mysql_result($result,$i,"PlaceAddress");
$PlaceState = mysql_result($result,$i,"PlaceState");
$PlaceCity = mysql_result($result,$i,"PlaceCity");
$PlaceZipCode = mysql_result($result,$i,"PlaceZipCode");
$HotelName = mysql_result($result,$i,"HotelName");
$HotelAddress = mysql_result($result,$i,"HotelAddress");
$HotelCity = mysql_result($result,$i,"HotelCity");
$HotelState = mysql_result($result,$i,"HotelState");
$HotelZipCode = mysql_result($result,$i,"HotelZipCode");
$HotelPhoneNumber = mysql_result($result,$i,"HotelPhoneNumber");
$HotelRate = mysql_result($result,$i,"HotelRate");
if(isset($ScheduleLink)){
$CompAgendaLink = "";
$CompAgendaLinkEnd = "";
}
else {
$CompAgendaLink = "";
$CompAgendaLinkEnd = "";
}
if($IsClosed == 1) {
$IsClosedCode = "".$LocationName." is SOLD OUT! |
";
}
else {
$IsClosedCode = "";
}
print "
|
|
|
|
|
".$CompAgendaLink."".$LocationName.$CompAgendaLinkEnd." |
".$CompAgendaLink."".$CompetitionDate.$CompAgendaLinkEnd." |
".$CompAgendaLink."".$DeadlineDate.$CompAgendaLinkEnd." |
".$CompAgendaLink."".$RebateDate.$CompAgendaLinkEnd." |
".$CompAgendaLink."".$PlaceName.$CompAgendaLinkEnd." |
".$IsClosedCode." ";
$i++;
}
?>