RE: [PHP-DB] What wrong with my Query??

Harry, I think you could also just use backticks around limit as occurs in the table creation statement below. David > limit is a mysql keyword...change that field name and the corresonding names > in your sql > bastien > > From: "HarryG" <harry1980@gmail.com> > > To: php-db@lists.php.net > > Subject: [PHP-DB] What wrong with my Query?? > > Date: Fri, 25 Mar 2005 16:26:38 +1100 > > > > What the hell is wrong with this MYSQL query?? PHP keeps giving me the > > error message: > > > > You have an error in your SQL syntax. Check the manual that corresponds to > > your MySQL server version for the right syntax to use near 'limit=20000, > > name='test1', email='atest@test.com', password='t > > > > $query = "INSERT INTO mfadmin SET id='', account='$accname_lc', > > limit=$plans, name='$yourname', email='$email', > > password='$password', > > lastlogin='$datetoday', datecreated='$datetoday', expiry='$expirydate', > > lastip=123.123.123.123"; > > > > This is my table structure > > CREATE TABLE admin ( > > id int(10) unsigned NOT NULL auto_increment, > > account varchar(50) NOT NULL default '', > > limit int(10) unsigned NOT NULL default '0', > > name varchar(50) NOT NULL default '', > > email varchar(50) NOT NULL default '', > > password varchar(50) NOT NULL default '', > > lastlogin varchar(50) NOT NULL default '', > > datecreated varchar(50) NOT NULL default '', > > expiry varchar(50) NOT NULL default '', > > lastip varchar(50) NOT NULL default '', > > PRIMARY KEY (id) > > ) TYPE=MyISAM;