Re: Unknown Table i field list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Have you tried :
$query = "INSERT INTO formcom(fname, lname, email, comment, ip) VALUES
('$fname','$lname','$email'.'$comment','$ip')"
or die('error in query');
tholland
----- Original Message ----- From: "Gary" <gpaul@xxxxxxxxxxxxxxxx>
To: <php-general@xxxxxxxxxxxxx>
Sent: Monday, October 11, 2010 8:09 PM
Subject:  Unknown Table i field list


I am getting an error of "unkown talbe "formcom" in field list".

I dont understand this. I have a talbe called formcom in the database, in fact I created this talbe to replace the first one named comments just in case the table name comments was not allowed.

I have used this same script a number of time, this is the first time I am getting this error

Here is the scritpt


$dbc = mysqli_connect('server','username',password','db name')
or die('Error connecting to MySQL server');

$query = "INSERT INTO formcom(fname, lname, email, comment, ip)" . "VALUES ('$fname','$lname','$email'.'$comment','$ip')"
or die('error in query');

$result = mysqli_query($dbc, $query)
or die('Error in Result');

mysqli_close($dbc);

I have also tried formcom.fname, formcom.lname, formcomemail, formcomcomment, formcom.ip

I have double triple quad checked to make sure I did not have comment and comments mix up.

Anyone be able to help me?

Thank you

Gary


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux