Unable to connect to the database server");
exit();
}
// Select the database
if (! @mysql_select_db($database) )
{
echo( "Unable to locate database ");
exit();
}
// get all show from today forward
$count = 0;
$result = mysql_query( "SELECT * FROM events WHERE loc_date >= now()");
if ($result)
{
// display first show not passed
while ($row = mysql_fetch_array($result) )
{
//show date & time
$count += 1;
if ($count > 1)
{
echo "| | ";
}
echo "| ";
echo(date("D F j, Y",mysqldate_to_unix_timestamp($row["loc_date"])));
echo(" at ");
echo(date("g:i a",mktime(substr($row["loc_date"],11,2),substr($row["loc_date"],14,2),substr($row["loc_date"],17,2))));
echo " | ";
echo " | ";
//show venue
echo("");
echo((ctype_space($row["venue_link"]) or is_null($row["venue_link"]))?
$row["venue_name"]:
"" . $row["venue_name"] . "");
//show venue city/state
echo(", ");
echo($row["loc_city"]);
echo((ctype_space($row["loc_ctry"]) or is_null($row["loc_ctry"]))?
" " . $row["loc_st"] :
" " . $row["loc_ctry"]);
echo "
";
//show additional information
echo(!(ctype_space($row["loc_other"]) or is_null($row["loc_other"]))?
$row["loc_other"]:
" ");
echo " | ";
}
if ($count < 1)
{
echo("| ");
echo("No shows currently scheduled");
echo(" | ");
echo("| | ");
echo("| | ");
echo("| | ");
}
}
?>
|