| Bastien Koert 2005-03-25, 3:55 am |
| 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;
|