Simple Form Insert Problem
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:
The testform.php file:
<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">
For some reason, the output isn't written into the correct tables? What's wrong here? Thanks!
@mysql_select_db($database) or die( "Unable to select database");
$query="INSERT INTO game_titles (gameID,gametitle,esrbrating) VALUES(DEFAULT,$title,$esrb)";
echo "It worked."
try the following:
$query="INSERT INTO game_titles (gameID,gametitle,esrbrating) VALUES(DEFAULT,'$title','$esrb')";
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?
Last edited by Tusserte; 09-21-2007 at 06:03 PM.
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?
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!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)