Gigs

gigs.php

<title>Gigs</title>
<?php

print "<link rel='stylesheet' type='text/css' href='css/viewall.css' />";
print "<script src='scripts/scotfolk.js'></script>";
mysql_connect('localhost','root','3107') or die(mysql_error());
mysql_select_db('a09002039') or die(mysql_error());

$findday = mysql_query("SELECT DISTINCT day FROM gig");
$findtown = mysql_query("SELECT DISTINCT town FROM gig");
$findband = mysql_query("SELECT DISTINCT band FROM gig");
$findvenue = mysql_query("SELECT DISTINCT venue FROM gig");

if ($_GET['sday'] == null) { $sday = '%'; } else { $sday = $_GET['sday']; }
if ($_GET['stown'] == null) { $stown = '%'; } else { $stown = $_GET['stown']; }
if ($_GET['sband'] == null) { $sband = '%'; } else { $sband = $_GET['sband']; }
if ($_GET['svenue'] == null) { $svenue = '%'; } else { $svenue = $_GET['svenue']; }


print "<div id='display'>Gigs by <select name='sband'><option selected value='%'>any band</option>";
while ($bands = mysql_fetch_array($findband)){
print "<option value='%$bands[0]%'>$bands[0]</option>";
}
print "</select> on <select name='sday'><option selected value='%'>any day</option>";
while ($days = mysql_fetch_array($findday)) {
print "<option value='%$days[0]%'>day $days[0]</option>";
}
print "</select> of the week in <select name='stown'><option selected value='%'>any town</option>";
while ($towns = mysql_fetch_array($findtown)) {
print "<option value='%$towns[0]%'>$towns[0]</option>";
}
print "</select> in the venue <select name = 'svenue'><option selected value='%'>any</option>";
while ($venues = mysql_fetch_array($findvenue)) {
print "<option value='%$venues[0]%'>$venues[0]</option>";
}
print "</select><button type='button' onclick='showGigs()'>Go</button>";

$query = sprintf("SELECT id,day,town,band,venue,details FROM gig WHERE day LIKE '%s' AND town LIKE '%s' AND band LIKE '%s' AND venue LIKE '%s'", mysql_real_escape_string($sday), mysql_real_escape_string($stown), mysql_real_escape_string($sband), mysql_real_escape_string($svenue));
$result = mysql_query($query) or die(mysql_error()); ;

print "<table border='1'><tr><th>ID</th><th>Day of Week</th><th>City</th><th>Band</th><th>Venue</th><th>Details</th><th>Promotional</th></tr>";
while ($a = mysql_fetch_array($result)){
 print "<tr><td>$a[0]</td><td>$a[1]</td><td>$a[2]</td><td>$a[3]</td><td>$a[4]</td><td>$a[5]</td><td><a href='gigdetail.php?id=$a[0]' target='_blank'>Poster</a></td></tr>";
}
print "</table></div>";

?>