Reviews '17'"; } else if($_GET["systeem"] == "1") { $systeemid = "Product.systeem_id ='1'"; } else if($_GET["systeem"] == "2") { $systeemid = "Product.systeem_id ='2'"; } else if($_GET["systeem"] == "7") { $systeemid = "Product.systeem_id ='7'"; } else if($_GET["systeem"] == "4") { $systeemid = "Product.systeem_id ='4'"; } else if($_GET["systeem"] == "15") { $systeemid = "Product.systeem_id ='15'"; } else if($_GET["systeem"] == "3") { $systeemid = "Product.systeem_id ='3'"; } else if($_GET["systeem"] == "0") { $systeemid = "Product.systeem_id <>'17'"; } else if($_GET["systeem"] == "9") { $systeemid = "Product.systeem_id ='9'"; } else if($_GET["systeem"] == "10") { $systeemid = "Product.systeem_id ='10'"; } else { $systeemid = "Product.systeem_id <>'17'"; } $sql = "SELECT reviews.product_id AS prodid, reviews.id, Titel.titel, members.username, reviews.score5, reviews.xmldatum, Systeem.kortenaam AS systeem FROM reviews,Titel,members,Product,Systeem WHERE reviews.product_id = Product.id AND Product.titel_id = Titel.id AND reviews.auteur = members.id AND reviews.preview = '0' AND Systeem.id = Product.systeem_id AND ".$systeemid." ORDER BY ".$sort; $producten = mysql_query($sql); $inhoud = array(); //echo($sql); $i=0; while($row = mysql_fetch_array($producten)) { $inhoud[$i]= array(); $inhoud[$i][0] = $row["prodid"]; $inhoud[$i][1] = $row["titel"]; $inhoud[$i][2] = $row["username"]; $inhoud[$i][3] = $row["score5"]; $inhoud[$i][4] = $row["xmldatum"]; $inhoud[$i][5] = $row["systeem"]; $i++; } //print_r($inhoud); geefReviewLijst(array("Systeem", "Game", "Auteur", "Punt", "Datum"), $inhoud); ?>