include "header.php"; session_start(); $city = $_GET['city']; $goaantalplaatsen = mysqli_query($connectie,"SELECT * FROM `bt_plaats` WHERE `city` = $city"); $aantalstadions = mysqli_num_rows($goaantalplaatsen); $goaantalconcerten = mysqli_query($connectie,"SELECT bt_live.id, bt_plaats.googleearth FROM bt_live INNER JOIN bt_plaats ON bt_plaats.id = bt_live.plaats INNER JOIN bt_city ON bt_city.id = bt_plaats.city WHERE bt_city.id = $city"); $aantalconcerten = mysqli_num_rows($goaantalconcerten); $goeerstejaar = mysqli_query($connectie,"SELECT bt_live.datum FROM bt_live INNER JOIN bt_plaats ON bt_plaats.id = bt_live.plaats INNER JOIN bt_city ON bt_city.id = bt_plaats.city WHERE bt_city.id =$city ORDER BY `bt_live`.`datum` ASC LIMIT 1"); while ($row = mysqli_fetch_array($goeerstejaar)) { $datum = $row["datum"]; $day = substr ($datum, 6, 2); $month = substr ($datum, 4, 2); $year = substr ($datum, 0, 4); $date = str_replace("DD", $day, $dateformat); $date = str_replace("MM", $month, $date); $eerstejaar = str_replace("YYYY", $year, $date); } $golaatstejaar = mysqli_query($connectie,"SELECT bt_live.datum FROM bt_live INNER JOIN bt_plaats ON bt_plaats.id = bt_live.plaats INNER JOIN bt_city ON bt_city.id = bt_plaats.city WHERE bt_city.id =$city ORDER BY `bt_live`.`datum` DESC LIMIT 1"); while ($row = mysqli_fetch_array($golaatstejaar)) { $datum = $row["datum"]; $day = substr ($datum, 6, 2); $month = substr ($datum, 4, 2); $year = substr ($datum, 0, 4); $date = str_replace("DD", $day, $dateformat); $date = str_replace("MM", $month, $date); $laatstejaar = str_replace("YYYY", $year, $date); } while ($row = mysqli_fetch_array($goaantalconcerten)) { $concertidee = $row["id"]; // $googleearth = $row["googleearth"]; // $gpslocaties = $gpslocaties . "&markers=icon:http://www.bosstime.nl/images/bsmarker.png|" . $googleearth; $goaantalnummers = mysqli_query($connectie,"SELECT * FROM `bt_concertsongs` WHERE `concertid` = $concertidee"); $aantalnummers = $aantalnummers + mysqli_num_rows($goaantalnummers); } $goaantalverschillendenummers = mysqli_query($connectie,"SELECT bt_live.datum, bt_concertsongs.songid FROM bt_live INNER JOIN bt_concertsongs ON bt_live.id = bt_concertsongs.concertid INNER JOIN bt_plaats ON bt_plaats.id = bt_live.plaats INNER JOIN bt_city ON bt_city.id = bt_plaats.city WHERE bt_city.id =$city GROUP BY bt_concertsongs.songid"); $aantalverschillendenummers = mysqli_num_rows($goaantalverschillendenummers); $goaantalconcertplaatsen = mysqli_query($connectie,"SELECT bt_live.id, bt_plaats.googleearth FROM bt_live INNER JOIN bt_plaats ON bt_plaats.id = bt_live.plaats INNER JOIN bt_city ON bt_city.id = bt_plaats.city WHERE bt_city.id = $city GROUP BY googleearth"); while ($row = mysqli_fetch_array($goaantalconcertplaatsen)) { $googleearth = $row["googleearth"]; $gpslocaties = $gpslocaties . "&markers=icon:http://www.bosstime.nl/images/bsmarker.png|" . $googleearth; // $goaantalnummers = mysqli_query($connectie,"SELECT * FROM `bt_concertsongs` WHERE `concertid` = $concertidee"); // $aantalnummers = $aantalnummers + mysqli_num_rows($goaantalnummers); } include "includes/include_plaats.php"; if ($city=="") { $titel = $lang['MENU_CITIES']; $broodkruimel = ""; } else { $titel = $plaatsevent; $broodkruimel = '/' . $plaatsevent . ''; } if ($city<>"") { $paginatitel = '
" . $lang['CITY_NUMBERCONCERTS'] . " | $aantalconcerten | "; $links .= "
" . $lang['COUNTRY_FIRST'] . " | $eerstejaar | "; $links .= "
" . $lang['COUNTRY_LAST'] . " | $laatstejaar | "; $links .= "
" . $lang['COUNTRY_DIFFERENTLOCATIONS'] . " | $aantalstadions | "; $links .= "
" . $lang['COUNTRY_NUMBERPLAYED'] . " | $aantalnummers | "; $links .= "
" . $lang['COUNTRY_DIFFERENTNUMBER'] . " | $aantalverschillendenummers | "; $links .= "