Recent Games

[insert_php]
$con = mysql_connect(“baldo.ie”,”external”,”BaldoGames”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
};

$ids = array();
mysql_select_db(“highscores”, $con);
$games = mysql_query(“SELECT GAMEDATE,LENGTH, WINNERS, PLAYERS, COMMENTS FROM AGE_GAMES ORDER BY GAMEDATE DESC”);

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;
while($row = mysql_fetch_array($games))
{

echo “

“;
}
echo “

Date Logged	Length (mins)	Players	Winner(s)	Comments
“.substr($row[‘GAMEDATE’],0,10).”	” . $row[‘LENGTH’] . “	“. $row[‘PLAYERS’] . “	“. $row[‘WINNERS’] . “	” . $row[‘COMMENTS’] . “

“;
mysql_close($con);

[/insert_php]