Unknown Table i field list
| From: | Gary | Date: | Mon, 11 Oct 2010 19:09:35 +0000 |
| Subject: | Unknown Table i field list | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-308625@lists.php.net to get a copy of this message | ||
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