= NOW()"),0); if($total == 0) { echo "No events in the future, click here for the archive."; } else { if(!isset($_GET['page']) OR $_GET['page'] < 1) { $page = 0; $prev = " Vorige " . $cfg['per_page'] . ""; } else { $page = $_GET['page']; } $start = $page * $cfg['per_page']; $pages = $total / $cfg['per_page']; $pageplus = $page + 1; $pagemin = $page - 1; if($pageplus < $pages OR $pageplus == $pages) { $Volgende = " Next " . $cfg['per_page'] . " "; } if($pageplus >= $pages) { $Volgende = "Next " . $cfg['per_page'] . " "; } if($pagemin <= $pages AND !empty($_GET['page'])) { $prev = " Previous " . $cfg['per_page'] . " "; } else { $prev = " Previous " . $cfg['per_page'] . " "; } if($pagemin == "0") { $Volgende = " Next " . $cfg['per_page'] . " "; } $query = mysql_query("SELECT *,UNIX_TIMESTAMP(datum) AS datum FROM agenda WHERE datum >= NOW() ORDER BY datum ASC LIMIT $start, " . $cfg['per_page'] . ""); echo "
$prev   ]   Old Events   [   $Volgende

"; while($row = mysql_fetch_assoc($query)) { $row['datum'] = date("l, F jS Y",$row['datum']); ?>
Title: - #" . $row['id'] . ""; } ?>
Date:
Time:
Entrance:
Flyer: Click here
Music:
Line-Up:
Extra info:
   

$prev   ]   Old Events   [   $Volgende"; } } elseif(isset($_GET['act'])) { if($_GET['act'] == "archief") { $total = mysql_result(mysql_query("SELECT COUNT(1) FROM agenda WHERE datum < NOW()"),0); if($total == 0) { echo "No events in the archive, click here for upcoming events."; } else { if(!isset($_GET['page']) OR $_GET['page'] < 1) { $page = 0; $prev = " Previous " . $cfg['per_page'] . ""; } else { $page = $_GET['page']; } $start = $page * $cfg['per_page']; $pages = $total / $cfg['per_page']; $pageplus = $page + 1; $pagemin = $page - 1; if($pageplus < $pages OR $pageplus == $pages) { $Volgende = " Next " . $cfg['per_page'] . " "; } if($pagemin <= $pages AND !empty($_GET['page'])) { $prev = " Previous " . $cfg['per_page'] . " "; } else { $prev = " Previous " . $cfg['per_page'] . " "; } if($pageplus >= $pages) { $Volgende = "Next " . $cfg['per_page'] . " "; } if($pageplus > $pages) { $Volgende = " Next " . $cfg['per_page'] . " "; } $query = mysql_query("SELECT *,UNIX_TIMESTAMP(datum) AS datum FROM agenda WHERE datum < NOW() ORDER BY datum DESC LIMIT $start, " . $cfg['per_page'] . ""); echo "
$prev   ]   Upcoming Events   [   $Volgende
"; while($row = mysql_fetch_assoc($query)) { $row['datum'] = date("l, F jS Y",$row['datum']); ?>
Title: - #" . $row['id'] . ""; } ?>
Date:
Time:
Entrance:
Flyer: Klik hier
Music:
Line-Up:
Extra info:
   
$prev   ]   Upcoming Events   [   $Volgende
"; } } } else { echo "invalid action."; } ?>