// gets number after ? in url
$uri = $_SERVER["REQUEST_URI"];
$startnumber = strstr($uri, '?');
$string = str_replace("?" , "" , $startnumber);
$string = str_replace( "%20" , " ", $string);
$town = $string;
include ("../dbinfo.php");
?>
Gig Guide. Bands in . Music pubs in
include '../adds.php' ; ?>
Live Music in
Gig Guide. Bands in . Music pubs in
Gig Guide
$query=" select bandname, bandurl, venuename, venueurl, gigdate, enteredby from tempgig where town = '$town' and gigdate >= curdate() and gigdate <= Date_ADD( curdate(), INTERVAL 370 DAY )
group by gigdate, bandname , venuename
order by gigdate asc, bandname ";
$result=mysql_query($query);
$gigscount = mysql_num_rows($result);
?>
while ($thisrow=mysql_fetch_row($result)) //get one row at a time
{
$formattedDate = date("l d F ", strtotime($thisrow[4]));
$link= '../bandgiglist/?'. $thisrow[0];
$publink= '../pubmap/?'. $thisrow[2];
?>
if ($formattedDate <> $datetest) echo "
" ;
if ($formattedDate <> $datetest) echo "
" . $formattedDate . "
" ;
?>
at
$datetest=$formattedDate;
}
echo "
";
?>
There are gigs on this website.
include '../advert.php' ; ?>