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