Re: Unknown Table i field list

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