1) $showPrevLink = true; else $showPrevLink = false; if(($page * $numPerPage) < $totalNumGigs) $showNextLink = true; else $showNextLink = false; include("header.php"); echo ""; outputGenreSwitches("gigs"); echo "
"; if($totalNumGigs == 0) { echo "Sorry, there are currently no gigs to display."; } else { echo ''; $rowcount = 1; echo ""; while($row = mysql_fetch_array($result)) { $artistquery = "SELECT * FROM artists WHERE id = $row[artistID]"; $tempresult = mysql_query($artistquery); $artist_name = mysql_result($tempresult, 0, name); $datestamp = dateStringToUnixTimestamp($row[date]); if($datestamp != $lastdatestamp) $rowcount++; echo ""; $lastdatestamp = $datestamp; } echo '
DateArtist/VenueInfo/Tickets
"; if($datestamp != $lastdatestamp) echo "".date("l", $datestamp)."
".date("d/m/Y", $datestamp).""; if ($row[country] != 0) { $getcountries = mysql_query("SELECT * FROM countries WHERE id=$row[country]"); $country = mysql_result($getcountries, 0, country); } $notallowed = array("[", "]", "{", "}", ",", "*", "&", "^", "%", "/", "|", ";", ":", "?", "'", "(", ")"); $arname = $artist_name; $arname = str_replace($notallowed, "", $arname); $arname = str_replace(" ", "-", $arname); $paget = $arname; $paget = strtolower($paget); echo "
$artist_name
$row[venue], $country
$row[ticketline]
'; if(($showPrevLink == true) || ($showNextLink == true)) { if($siteGenre == "generic") $thisPageName = "gigs.html"; else $thisPageName = "gigs-$siteGenre.html"; $prevPage = $page - 1; $nextPage = $page + 1; echo "
"; if($showPrevLink == true) echo "<< previous page"; echo ""; if($showNextLink == true) echo "next page >>"; echo "
"; } } include("footer.php"); ?>