i am starting a gaming website and i am having a bit of a problem with them here is my first pahe index.php
PHP Code:
<html>
<head><title>Web Database Sample Index</title>
</head>
<body bgcolor=#ffffff>
<h1>Data from tabletest</h1>
<?
mysql_connect("localhost", "*****", "*****");
$query = "SELECT GameName,
Sub_date,
Dev_email,
Stage,
Genre,
Client,
Platform,
Interface,
Multiplayer,
Prizes,
Last_reviewed,Cost,
ESRBRating,
Game_URL FROM gameform";
$result = mysql_db_query("*****", $query);
if ($result) {
echo "Found these entries in the database:<ul>";
while ($r = mysql_fetch_array($result)) {
$GameName = $r["Game Name"];
$Sub_date = $r["Submission Date"];
$Dev_email = $r["Developers Email"];
$Stage = $r["Development Stage"];
$Genre = $r["Game Genre"];
$Client = $r["Client"];
$Platform = $r["Platform"];
$Interface = $r["Interface"];
$Multiplayer = $r["Multiplayer"];
$Prizes = $r["Prizes"];
$Last_reviewed = $r["Last Reviewed"];
$Cost = $r["Game Cost"];
$ESRBRating = $r["ESRBRating"];
$Game_URL = $r["Game URL"];
echo "<li>$GameName,
$Sub_date,
$Dev_email,
$Stage, $Genre,
$Client,
$Platform,
$Interface,
$Multiplayer,
$Prizes, $Last_reviewed,
$Cost,
$ESRBRating,
$Game_URL";
}
echo "</ul>";
} else {
echo "No data.";
}
mysql_free_result($result);
?>
<form name="form1" method="post" action="add_new_game.php">
<input type="submit" name="Submit" value="Add A New Game">
</form>
<p>
</body>
</html>