Code: Select all
INSERT INTO rdxls_users (usr,pwd,group,email,name,country,gender,dob,occupation,time,secret,answer,address,city,county,postcode,website) VALUES('username','password','normal','EMail', 'Name', 'UK','m','593132400','Job','1082022970', 'Hello' , 'Good Bye' , 'Address' , 'City' , 'County' , 'Post code' , 'website' )Code: Select all
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 'group,email,name,country,gender,dob,occupation,time,secret,answCode: Select all
CREATE TABLE `rdxls_users` (
`id` int(15) NOT NULL auto_increment,
`usr` varchar(20) NOT NULL default '',
`pwd` varchar(32) NOT NULL default '',
`group` varchar(20) NOT NULL default '',
`secret` tinytext NOT NULL,
`answer` tinytext NOT NULL,
`email` tinytext NOT NULL,
`name` text NOT NULL,
`country` varchar(5) NOT NULL default '',
`gender` char(1) NOT NULL default '',
`dob` int(11) NOT NULL default '0',
`occupation` tinytext NOT NULL,
`time` int(15) NOT NULL default '0',
`address` mediumtext NOT NULL,
`city` mediumtext NOT NULL,
`county` mediumtext NOT NULL,
`postcode` varchar(15) NOT NULL default '',
`website` text NOT NULL,
PRIMARY KEY (`id`)
)