""sueandant"" <hollandsath...@tiscali.co.uk> wrote in message news:4c8c262adea3459d815fe3e70ae10...@sueandantpc... > 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" <gp...@paulgdesigns.com> > To: <php-general@lists.php.net> > Sent: Monday, October 11, 2010 8:09 PM > Subject: [PHP] 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