Simple Form Insert Problem

[Tusserte]

Hello everyone, I have a question about a very basic form I've set up. I'm trying to get the hang of SQL select, but I first need to put some content in my SQL tables! For now, here is the code I've used:

The form on the page:

<form action="testform.php" method="post">
<input type="text" name="title" value="Game Title">
<input type="text" name="esrb" value="ESRB Rating">
<input type="Submit" value="Submit Title">
</form>

The testform.php file:

<?
$username="edited";
$password="edited";
$database="edited";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$title=$_POST['title'];
$esrb=$_POST['esrb'];
$query="INSERT INTO game_titles (gameID,gametitle,esrbrating) VALUES(DEFAULT,$title,$esrb)";
mysql_query($query);
echo "It worked."
?>

For some reason, the output isn't written into the correct tables? What's wrong here? Thanks!

[mattyblah]

try the following:

$query="INSERT INTO game_titles (gameID,gametitle,esrbrating) VALUES(DEFAULT,'$title','$esrb')";

[Tusserte]

Thanks a bunch! It fixed the problem! While I'm at it, may I ask how you get the form method to just include the PHP from my "testform.php" file instead of actually redirecting the browser to that file?

[Tusserte]

UPDATE: The form worked, but only once. For some reason, only id=0 goes in, and the form ignores the rest of the things I try to input. By the way, gameID is the auto_increment PRIMARY KEY and is supposed to be the generic INT number assigned to tell each row apart. The other variables are actual inputs. What am I doing wrong?

[Tusserte]

Another update: ignore the last update. I didn't see that there my phpmyadmin page scrolled, so I didn't see the extra: auto_increment and somehow thought I had set it before. Sorry! However, the question before still stands, I'm very curious . Thanks!