l200/gamemakersdetails.php
<?php
include('db1.php');
?>
<head>
<link rel="stylesheet" href="style.css">
</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 "<h1>Gamemaker: $row[Naam_game] </h1>";
echo "<h3> Oprichtjaar: $row[Jaar_opgericht], Stad hoofdkantoor: $row[Plaats], Ceo:$row[Ceo] </h3>";
$query = "select * from games
where bedrijfid = $bedrijfid
order by naam";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query");
echo "<div class=knoppen> ";
while($row = mysqli_fetch_array($result)){
echo "<h2><a href='games.php?Gameid=$row[Gameid]'> $row[naam]</a></h2>";
}
echo "</div>";
echo "<h2 class=hoofdpagina><a href='index.php'> hoofdpagina</a></h2>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse