thanks. Stupid me. I've been banging by head for the last two hours. "Bastien Koert" <bastien_k@xxxxxxxxxxx> wrote in message news:BAY21-F3F5D399CFF651F190352A9D410@xxxxxxxxxx > limit is a mysql keyword...change that field name and the corresonding names > in your sql > > bastien > > >From: "HarryG" <harry1980@xxxxxxxxx> > >To: php-db@xxxxxxxxxxxxx > >Subject: 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@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
