<?php
#require_once "DB.php";
$host = 'localhost';
$user = 'root';
$pass = '';
$database = '';
$dbc = mysqli_connect($host,$user,$pass,$database);
$sql = "select * from pokemon where National_Pokedex=".$_GET['id'];
#print $sql;
$result = mysqli_query($dbc,$sql);
$row = mysqli_fetch_array($result);
print "<h1>Details of $row[1] <i>($row[0])</i> </h1>";
print "<img src='http://upload.wikimedia.org/wikipedia/en/2/21/001Bulbasaur.png' /><p>";
print "Japenese Name = ".$row[2]."<br>";
$sql2 = "select * from pokemon where National_Pokedex=".$row[3];
#print $sql2;
$result2 = mysqli_query($dbc,$sql2);
$row2 = mysqli_fetch_array($result2);
print "Evolution = ".$row[3]."<br>";
print "Evolution (name) = ".$row2[1]."<br>";
print "<a href='index.php'>Go Back</a>";
#while ($row = mysqli_fetch_array($result)){
#echo "<a href='details.php?id=".$row['National_Pokedex']."'>".$row['English_name']."</a><br>";
#}
?>
Updated version