' . $teller . '' . $plaatsevent . '' . $date . '' . $lengte . ''; $teller++; } // MEESTE WERELDPREMIERES $meestewereldpremtabel; // MEESTE TOURPREMIERES $meestetourpremtabel; // LANGSTE SETLIJST $teller=1; $go=mysqli_query($connectie,"SELECT concertid,count(concertid) AS aantal FROM `bt_concertsongs` GROUP BY concertid ORDER BY count(concertid) DESC LIMIT 10"); while ($row = mysqli_fetch_array($go)) { $concertid = $row["concertid"]; $aantal = $row["aantal"]; $go2=mysqli_query($connectie,"SELECT id,datum,plaats,lengte FROM `bt_live` WHERE id=$concertid"); while ($row = mysqli_fetch_array($go2)) { $id = $row["id"]; $datum = $row["datum"]; $plaats = $row["plaats"]; $lengte = $row["lengte"]; $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); $date = str_replace("YYYY", $year, $date); $go3=mysqli_query($connectie,"SELECT city FROM bt_plaats WHERE id = '$plaats' "); while ($row = mysqli_fetch_array($go3)) { $city = $row["city"]; include "includes/include_plaats.php"; } } $langstesetlijsttabel .= '' . $teller . '' . $plaatsevent . '' . $date . '' . $aantal . ''; $teller++; } // CONCERTEN HET DICHTSTBIJ JOU $dichtsbijtabel; // CONCERTEN HET VERST AF VAN JOU $verstwegtabel; // MEESTE PERSOONLIJKEPREMIERES $meesteperspremtabel; ?>

HOME//

UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER"; $MOSTTOURPREMtabel = "UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER"; $CONCERTSNEARtabel = "UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER"; $MOSTPERSPREMtabel = "UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER"; $CONCERTSFARtabel = "UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER"; ?>