Re: Unknown Table i field list

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

 



""sueandant"" <hollandsathome@xxxxxxxxxxxxx> wrote in message 
news:4C8C262ADEA3459D815FE3E70AE10F01@xxxxxxxxxxxxxx
> 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



Just tried it, still the same message...

Thank you for trying

Gary 



__________ Information from ESET Smart Security, version of virus signature database 5521 (20101011) __________

The message was checked by ESET Smart Security.

http://www.eset.com





-- 
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