\n"; print "\n"; include("config.php"); echo "\n"; //-------------------------------------------------- //--------H U G E C A S E S T A T E M E N T //-------------------------------------------------- //--------all upcoming concerts //-------------------------------------------------- //-------------------------------------------------- if ($id=="") { //QUERY $query = 'SELECT * from cwo_UpcomingConcerts AS a, cwo_Contacts AS b where a.contact_id=b.contact_id and date>CURDATE() ORDER BY date ASC'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); print ""; if (mysql_num_rows($result) == 0 ) { print "



There are no upcoming concerts at this time."; } while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $title=$line["title"]; $upcoming_id=$line["upcoming_id"]; $contact_id=$line["contact_id"]; $contact=$line["contact"]; $contact_email=$line["contact_email"]; $date=$line["date"]; $print_date=$line["print_date"]; $city=$line["city"]; $state=$line["state"]; $venue=$line["venue"]; $venue_url=$line["venue_url"]; $venue_map_url=$line["venue_map_url"]; $contact_id=$line["contact_id"]; $details=$line["details"]; $image=$line["image"]; $image_thumb=$line["image_thumb"]; echo "\n"; echo "\n"; echo "\n"; } echo "
\n"; print "

\n"; print "".$city." ".$state." - ".$print_date."\n"; print "

\n"; print "
".$title."
\n"; print "		\n"; print ""; print "\n"; print "
\n"; } //-------------------------------------------------- //--------H U G E C A S E S T A T E M E N T //-------------------------------------------------- //-------------------------------------------------- //--------one show //-------------------------------------------------- else { // Performing SQL query $query = 'SELECT a.*, b.* from cwo_UpcomingConcerts AS a, cwo_Contacts AS b where a.contact_id=b.contact_id and upcoming_id='.$id; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML $line = mysql_fetch_array($result, MYSQL_ASSOC); $title=$line["title"]; $contact_id=$line["contact_id"]; $contact=$line["contact"]; $contact_email=$line["contact_email"]; $date=$line["date"]; $print_date=$line["print_date"]; $city=$line["city"]; $state=$line["state"]; $venue=$line["venue"]; $venue_url=$line["venue_url"]; $venue_map_url=$line["venue_map_url"]; $contact_id=$line["contact_id"]; $details=$line["details"]; $image=$line["image"]; //top of html file already printed echo "\n"; echo ""; echo "
"; echo ""; echo ""; echo "

"; echo $city." ".$state." - ".$print_date; echo "

"; echo $title."
".$details; echo "
\n\n"; echo "

"; echo "".$venue.""; echo "
"; echo "(map)"; echo "
\n\n"; echo "Contact: ".$contact."\n\n"; } //-------------------------------------------------- //--------E N D H U G E C A S E S T A T E M E N T //-------------------------------------------------- //-------------- print ""; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?>