Untitled

<html>
<body>

<h1>Freenode ##PSN Official Website<h1>
<h6>Member of the Citizen Network<h6>
<table align="center">
<tr>
<!--
<td align="right">
<form action="insert.php" method="post">
Firstname: <input type="text" name="firstname" /><br>
Lastname: <input type="text" name="lastname" /><br>
Age(optional):  <input type="text" name="age" /><br>
PSN-ID: <input type="text" name="psnid" /><br>
Country: <input type="text" name="country" /><br>
E-mail: <input type="text" name="mail" /><br>
Password: <input type="password" name="pwd" /><br>
Confirm: <input type="password" name="pwd" /><br>
Irc nicknames: <input type="text" name="ircnick" /><br>
<input type="submit" /><br>
</td>
-->
<!-- Member list -->
<td>
<?php
$con = mysql_connect("localhost","CitiNetwork","FAKEPASWP");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("TEST_db", $con);

$result = mysql_query("SELECT * FROM Psn ORDER BY psnid");

echo "<table border='0'>
<tr>
<th>PSN-ID</th>
<th>Country</th>
<th>Irc Nick</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['psnid'] . "</td>";
 /* echo "<td>" . $row['FirstName'] . "</td>";
  echo "<td>" . $row['LastName'] . "</td>"; */
  echo "<td>" . $row['country'] . "</td>";
  echo "<td>" . $row['ircnick'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
</td>
<!-- end member list-->
</tr>
</table>
</body>
</html>