/* database login */
include 'mysqllogin.php';
include 'directories.php';
$sql = "SELECT COUNT(*) FROM Concert WHERE (Time > NOW())";
$sql_result = mysql_query($sql,$conn) or die(mysql_error()."
$sql");
$row = mysql_fetch_array($sql_result);
if ($row[0] == 0)
}
else {
/* Get the information for the current concerts */
$sql = "SELECT Concert_Id, Name, DATE_FORMAT(Time,'%W, %M %e, %Y %l:%i %p') AS Time2, Venue AS Place, City, State, Handicap, Hearing, Thumbnail as Picture, Summary, Series FROM Concert WHERE (Time > NOW()) ORDER BY Time";
$sql_result = mysql_query($sql,$conn) or die (mysql_error());
?>
![]() |
![]() |
![]() |
![]() |
![]() |
![]()
![]()