Concert Listings Europe. Gig Guide Europe. European Tour Dates

require ('fconnection.php'); $connection = connectToDatabase(); if (!$connection) { die ('Could not connect'); } $querys = mysql_query("SELECT distinct act_name, act_id FROM acts, events WHERE acts.act_id=events.act_id AND events.event_date >= '$current_date' ORDER BY act_name")or die (mysql_error()); $querys = mysql_query("SELECT distinct venue_country FROM venue_country ORDER BY venue_country")or die (mysql_error()); echo ""; echo "All"; while ($data = mysql_fetch_assoc($querys)) { echo " $data[venue_country]\n"; } echo "\n"; echo "Select Country "; echo "
"; $querys = mysql_query("SELECT distinct venue_city FROM venue_city ORDER BY venue_city")or die (mysql_error()); echo ""; $querys = mysql_query("SELECT distinct act_id FROM events WHERE events.event_date >= '$current_date'")or die (mysql_error()); $querys = mysql_query("SELECT distinct act_name FROM acts ORDER BY act_name")or die (mysql_error()); echo "\n"; echo "All\n"; while ($data = mysql_fetch_assoc($querys)) { echo " $data[act_name]\n"; } echo "\n"; echo "Select Act"; echo "
"; $querys = mysql_query("SELECT distinct act_genre FROM act_genre ORDER BY act_genre")or die (mysql_error()); echo "\n"; echo "All"; while ($data = mysql_fetch_assoc($querys)) { echo " $data[act_genre]\n"; } echo "\n"; echo "Select Genre "; echo "
"; echo ""; echo "Anytime\n"; echo "Today\n"; echo "Tomorrow\n"; echo "Next 7 Days\n"; echo "Next 14 Days\n"; echo "Within a Month\n"; echo "\n"; echo "Choose When"; ?> Date (mm/dd/yyyy)

                              

 

             © 2011 Concertracker