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
