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

lastip value should be quoted lastip='123.123.123.123' -----Mensagem original----- De: HarryG [mailto:harry1980@gmail.com] Enviada: sexta-feira, 25 de Março de 2005 5:27 Para: php-db@lists.php.net Assunto: [PHP-DB] What wrong with my Query?? 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;