mysql_query insert problem
Jeg har brugt en masse tid på at prøve at rette denne mysql_query:mysql_query("INSERT INTO `activations` (email, key, time, ip) VALUES ('".$email."', '".$createActivationKey."', '".$time."', '".$_SERVER['REMOTE_ADDR']."')") or die(mysql_error());
Men den bliver ved med at sige:
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 'key, time, ip) VALUES ('liljosen@hotmail.com', '53efdf048351dcf9274f2ae2a4ed0a2d' at line 1
Hvad skal jeg gøre for at få den til at virke?
Her er min tabel:
CREATE TABLE `activations` (
`id` int(11) NOT NULL auto_increment,
`email` varchar(255) NOT NULL,
`key` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Tak på forhånd
