Re: Unknown Table i field list

On Mon, 2010-10-11 at 15:46 -0400, Gary wrote: > I used, and have always used phpmyadmin to create the tables. As I say, it > is not the first time doing this, but I believe it is the first time getting > the error. > > To Alexander, yes I had, ,in fact I simply C/p the script from anohter > scritp into the same db... > > Thank you > > Gary > > > > "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message > news:1286826171.3415.2.camel@localhost.localdomain... > > On Mon, 2010-10-11 at 15:09 -0400, Gary wrote: > > > >> 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 > >> > >> > >> > > > > > > What's the create table syntax that was used to create that table. Can > > you get it from the software you're using to create/modify the DB rather > > than type it to reduce the chance of omitting any errors that were > > introduced? > > > > Thanks, > > Ash > > http://www.ashleysheridan.co.uk > > > > > > > > > > > > __________ Information from ESET Smart Security, version of virus > > signature database 5521 (20101011) __________ > > > > The message was checked by ESET Smart Security. > > > > http://www.eset.com > > > > > > > > __________ Information from ESET Smart Security, version of virus signature database 5521 > (20101011) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > But can you post the create table syntax it used to create that table? In phpMyAdmin you can get this by going to the export tab. Thanks, Ash http://www.ashleysheridan.co.uk