JREAM Posted July 8, 2009 Share Posted July 8, 2009 Im not sure whats wrong with this 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 '; INSERT INTO files VALUES("1","admins_and_employees.txt","0","0","06/13/2009' at line 8 CREATE TABLE IF NOT EXISTS `files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `file` varchar(255) NOT NULL, `assign_user` int(11) NOT NULL, `assign_project` int(11) NOT NULL, `date_created` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; INSERT INTO files VALUES("1","admins_and_employees.txt","0","0","06/13/2009"); INSERT INTO files VALUES("2","users.txt","0","1","06/13/2009"); Quote Link to comment Share on other sites More sharing options...
JREAM Posted July 8, 2009 Author Share Posted July 8, 2009 gosh im going to pass out i will check this in the monrning if anyone has time to answer, if not thats all good too i will rpobably have more energ y to study later Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.