lastip value should be quoted lastip='123.123.123.123' -----Mensagem original----- De: HarryG [mailto:[EMAIL PROTECTED] 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='[EMAIL PROTECTED]', 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; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php