// Include the session settings and start the session
require_once("SessionSettings.php");
session_start();
$DataBase = "Not Used";
// Inlcude Database script
require_once "Admin/DatabaseConnection.php";
require_once ("NavBar.php");
// connect to mysql Bee Gees Story database
$dbHandle=ConnectToMySql();
ConnectToDatabase($DataBase,$dbHandle);
$dbResult = mysql_query("SELECT *, YEAR(Date) AS Year, MONTHNAME(Date) AS Month, DATE_FORMAT(Date,'%a %D') AS DisplayDate
FROM tourdates WHERE Date>'2013-12-28' ORDER BY Date ASC",$dbHandle);
OpenPage("TourDates","","Jive Talkin Bee Gees Tribute Band - Tour Dates");
?>
$OldMonth="";
$Color="TableColumn2";
while ($TourDate = mysql_fetch_object($dbResult))
{
//if ($TourDate->Show!="Jive") continue;
// Fetch the type of show it is
$ShowType = "BG";
$TextColor="#66ff66";
$Description = "Bee Gees Concert
A full two hour Bee Gees show starring Jive Talkin";
if ($TourDate->Show=="Winner") { $ShowType="DH"; $TextColor="#FF00ff"; $Description="Double Header Concert
Featuring both the music of ABBA and the BEE GEEs.";}
else
if ($TourDate->Show=="Legacy") { $ShowType="LG"; $TextColor="#FF6600"; $Description="III Legends
Featuring both the music of Simon & Garfunkel, The Bee Gees and The Beatles";}
else
if ($TourDate->Show=="Voulez") {$ShowType="AB";$TextColor="#6666ff";$Description="Mad About ABBA
Featuring ABBAs Greatest Hits! Live In Concert.";}
// If an ABBA only show then dont show on Bee Gees Website
//if ($ShowType=="AB") continue;
$Month = $TourDate->Month." ".$TourDate->Year;
if ($Month!=$OldMonth)
{
if ($OldMonth!="") print ("| |
");
print ("| ".$Month." |
");
$OldMonth=$Month;
$Color="TableColumn2";
}
if ($Color=="TableColumn1") $Color="TableColumn2";
else $Color="TableColumn1";
$TourDate->Address = str_replace("\n","",$TourDate->Address);
$TourDate->Address = str_replace("\r","",$TourDate->Address);
print("
| ".$TourDate->DisplayDate." |
".stripslashes($TourDate->Location)." |
".stripslashes($TourDate->Venue)." |
".stripslashes($TourDate->Telephone)." |
Website |
".$ShowType." |
");
}
?>
ClosePage();
?>