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