include_once("common/taal.php"); include_once("common/bb_func.php"); include_once("common/dbconnect.php"); include_once("common/functions.php"); $p = 'fotograaf'; $currentpage = 'xpo'; $xpoID = mysql_real_escape_string($_GET[xpoID]); if($xpoID) $pagequery = "SELECT * FROM `xpo` WHERE xpoID = '$xpoID' LIMIT 1"; else{ $datum = date("Y-m-d"); $pagequery = "SELECT * FROM `xpo` ORDER BY `einddatum` DESC LIMIT 1"; } //WHERE einddatum >= '$datum' $getpage = mysql_query($pagequery); $myrow = mysql_fetch_assoc($getpage); if(!$xpoID) $xpoID = $myrow[xpoID]; include("header.php"); $yearquery = "SELECT DISTINCT YEAR(begindatum) AS year FROM xpo ORDER BY begindatum,einddatum DESC"; $getyear = mysql_query($yearquery); echo("
$year[year]: | "); $xponavquery = "SELECT xpoID FROM xpo WHERE YEAR(begindatum) = '$year[year]' ORDER BY begindatum,einddatum DESC"; $getxponav = mysql_query($xponavquery); $i = 1; while($xponav = mysql_fetch_assoc($getxponav)){ if($xponav[xpoID] != $xpoID) echo("".$i." | "); else echo("".$i." | "); $i++; } } echo("