l201/gamemakersdetails.php

<?php include('db1.php'); ?> </head> <body> <?php $bedrijfid = $_GET['bedrijfid']; $query = "select * from Gamemakers where bedrijfid = $bedrijfid order by Naam_game "; $result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query"); $row = mysqli_fetch_array($result); echo "<h2>$row[Naam_game] </h2>"; echo "<p> $row[Jaar_opgericht], $row[Plaats], $row[Ceo] </p>"; $query = "select * from games where bedrijfid = $bedrijfid order by naam"; $result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query"); while($row = mysqli_fetch_array($result)){ echo "<div><a href='games.php?Gameid=$row[Gameid]'> $row[naam]</a></div>"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse