What wrong with my Query??
| From: | HarryG | Date: | Fri, 25 Mar 2005 05:26:38 +0000 |
| Subject: | What wrong with my Query?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-39035@lists.php.net to get a copy of this message | ||
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;