RE: [PHP] Inserting records question

It might also be a factor, but the variable containing the table name is $table (not $table1 as coded in the query string). Warren Vail warren@vailech.net > -----Original Message----- > From: Philip Hallstrom [mailto:php@philip.pjkh.com] > Sent: Thursday, September 08, 2005 6:41 PM > To: Iggep > Cc: php-general@lists.php.net > Subject: Re: [PHP] Inserting records question > > > > 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? > > A lot of single quotes... around the parameters you are inserting... > > add in a print($tc_query) and see what that looks like... run that > directly in mysql and it will give you more details on the error. > > Or, make it look like this: > > $tc_query = "INSERT INTO $tablel VALUES(NULL, '$lname', '$fname', > '$machine_name', '$email_addr', '$problem', NULL)"; > > I'd also suggest you read this page: > http://www.php.net/mysql_escape_string good luck! -p -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php