RE: [PHP-DB] What wrong with my Query??

Actually, your sql syntax is wrong. The SET keyword if for UPDATE not
INSERT=20

Use=20
$sql =3D "INSERT INTO mfadmin
 (id,account,planlimit,name,email,passwor
d,lastlogin,datecreated,expiry,l
astip) VALUES
 ('','$accname_lc','$plans','$yourname','
$email','$password','$datetoday'
,'$datetoday','$expirydate','123.123.123.123')";


Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"


-----Original Message-----
From: HarryG [mailto:harry1980@gmail.com]=20
Sent: Thursday, March 24, 2005 11:27 PM
To: php-db@lists.php.net
Subject: [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=3D20000, name=3D'test1', email=3D'atest@test.com', password=3D't=20

$query =3D "INSERT INTO mfadmin SET id=3D'', account=3D'$accname_lc',
limit=3D$plans, name=3D'$yourname', email=3D'$email', =
password=3D'$password',
lastlogin=3D'$datetoday', datecreated=3D'$datetoday', =
expiry=3D'$expirydate',
lastip=3D123.123.123.123";
=20
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=3DMyISAM;