l201/games.php

<?php include('db1.php'); ?> </head> <body> <?php $Gameid = $_GET['Gameid']; $query = "select * from games where Gameid = $Gameid"; $result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query"); $row = mysqli_fetch_array($result); echo "<h2>$row[naam] </h2>"; echo "<p> $row[uitgave], $row[genre], $row[engine] </p>"; $query = "select * from games g, Consoleinfo ci, consoles c where ci.Gameid = $Gameid and ci.consoleid = c.consoleid and g.Gameid = $Gameid"; $result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query"); while($row = mysqli_fetch_array($result)){ echo "<div><a href='console.php?consoleid=$row[consoleid]'> $row[naam_con]</a></div>"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse