Jump to content

Mysql query through php


JREAM

Recommended Posts

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");

Link to comment
https://forums.phpfreaks.com/topic/165159-mysql-query-through-php/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.