There you have to consider the following things; 1, the query is mixed with INSERT and UPDATE staments 2, `id` is a numeric data type field, so the value should be mentioned in numeric form (instead of string) 3, LIMIT is a keyword of SQL statement 4, `lastip` field is a string datatype, so the value should be mentioned in string form 5, if the query is just for insertion of a new record, there might be no need to specify value for `id` field as it is an auto_increment field R. Kumaran India : -----Original Message----- : From: HarryG [mailto:harry1980@xxxxxxxxx] : Sent: Thursday, March 24, 2005 11:27 PM : To: php-db@xxxxxxxxxxxxx : Subject: 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@xxxxxxxx', 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
