session_start(); ?> include("functions/functions.php"); include("functions/verbinden.php"); $sort = "news.id DESC"; if($_GET["systeem"] == "") { $systeemid = "1=1"; } else if($_GET["systeem"] == "1") { $systeemid = "news.systeem_id ='1'"; } else if($_GET["systeem"] == "2") { $systeemid = "news.systeem_id ='2'"; } else if($_GET["systeem"] == "7") { $systeemid = "news.systeem_id ='7'"; } else if($_GET["systeem"] == "4") { $systeemid = "news.systeem_id ='4'"; } else if($_GET["systeem"] == "15") { $systeemid = "news.systeem_id ='15'"; } else if($_GET["systeem"] == "9") { $systeemid = "news.systeem_id ='9'"; } else if($_GET["systeem"] == "0") { $systeemid = "news.systeem_id ='20'"; } else if($_GET["systeem"] == "10") { $systeemid = "news.systeem_id ='10'"; } else if($_GET["systeem"] == "8") { $systeemid = "news.systeem_id ='8'"; } else if($_GET["systeem"] == "13") { $systeemid = "news.systeem_id ='13'"; } else if($_GET["systeem"] == "17") { $systeemid = "news.systeem_id ='17'"; } else { $systeemid = "1=1"; } $sql = "SELECT news.id, Systeem.id AS systeemid, Systeem.kortenaam, news.xmldatum, news.title FROM Systeem, news WHERE news.systeem_id = Systeem.id AND ".$systeemid." ORDER BY ".$sort." LIMIT 0,75"; $producten = mysql_query($sql); $inhoud = array(); //echo($sql); $i=0; while($row = mysql_fetch_array($producten)) { //$sql7 = "SELECT Count(news_reacties.id) AS aantal FROM news_reacties WHERE news_reacties.nid = '".$row["id"]."'"; //$producten7 = mysql_query($sql7); //$row7 = mysql_fetch_array($producten7); //if($row7["aantal"] == "1") //{ //$reacties = $row7["aantal"]." Reactie"; //} //else //{ //$reacties = $row7["aantal"]." Reacties"; //} $inhoud[$i]= array(); $inhoud[$i][0] = $row["id"]; $inhoud[$i][1] = $row["kortenaam"]; $inhoud[$i][2] = $row["title"]; $inhoud[$i][3] = "onb"; $inhoud[$i][4] = $row["xmldatum"]; $inhoud[$i][5] = $row["kortenaam"]; $i++; } $logo = geefSysteemLogo($_GET["systeem"]); include ("header.inc"); ?> //geefLetters(); ?>