Inserting records question
| From: | Iggep | Date: | Fri, 09 Sep 2005 00:48:26 +0000 |
| Subject: | Inserting records question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-222056@lists.php.net to get a copy of this message | ||
Still learning, so sorry if this sounds really simply noobish. But as I
understand things currently this should work. But doesn't. I've been
looking over tutorials but just don't see whatever the problem is.
I created a simple table with the following fields (in order)
tc_id (auto nmbr)
lname
fname
machine_name
email_addr
problem
date_time_submitted (timestamp)
And I'm trying to run this insert from form input.
$username="somename";
$password="somepass";
$database="somedb";
$table="sometable";
mysql_connect(localhost,$username,$password);
@mysql_select_db("$database") or die("Unable to Connect to DB");
$tc_query = "INSERT INTO $tablel VALUES(NULL, $lname, $fname, $machine_name,
$email_addr, $problem, NULL)";
$result = mysql_query($tc_query);
mysql_close();
So what exactly do I seem to be missing here?