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

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;