Poor Mike...
This is the code I'm using minus the log in details...
<?php
//connect
$connect = mysql_connect("localhost", "dbname", "password");
//select db
mysql_select_db("dbname", $connect);
//query db
$result = mysql_query("SELECT * FROM games WHERE Category='Adventure'", $connect);
//start table
echo ("<table>");
//list all games in table
for ($x=0; $x < mysql_num_rows($result); $x++)
{
$row = mysql_fetch_assoc($result) ;
echo ("<tr style='padding-top:10'>");
echo ("<td><a href='http://www.games2go.co.uk/game/");
echo $row['URL'];
echo ("'>");
echo ("<img src='");
echo $row['ImageURL'];
echo ("' border='0' width='70' height='59'>");
echo ("</a>");
echo ("</td>");
echo ("<td style='padding-left:10'><font color='000000'><b>");
echo ("<a href='http://www.games2go.co.uk/game/");
echo $row['URL'];
echo ("'>");
echo $row['Name'];
echo ("</font></a></b>");
echo (": ");
echo $row['Description'];
echo ("</td></tr>");
}
?>