Re: Unknown Table i field list

"Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message news:1286826713.3415.3.camel@localhost.localdomain... > 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 > > -- phpMyAdmin SQL Dump -- version 2.11.9.4 -- http://www.phpmyadmin.net -- -- Host: 10.8.11.213 -- Generation Time: Oct 11, 2010 at 01:59 PM -- Server version: 5.0.91 -- PHP Version: 5.2.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: sanatized -- -- -------------------------------------------------------- -- -- Table structure for table formcom -- CREATE TABLE formcom ( id int(11) NOT NULL auto_increment, fname varchar(20) NOT NULL, lname varchar(20) NOT NULL, email varchar(50) NOT NULL, comment varchar(4000) NOT NULL, ip varchar(20) NOT NULL, submitted timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table formcom -- Here you go. Thank you 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