Drugs Help

[EpicFuse]

Please tell me whats wron with the query below is the error i get thanks

Error

SQL query:

INSERT INTO `drugs`

VALUES ( 2, 'John', 'him', 'Crack', 'You start lining up the crack to snort, you do this a few times with $name then you walk home. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 20, 20, 999, 20, 200, 6, 0 )

INSERT INTO `drugs`

VALUES ( 3, 'Jay', 'him', 'Crystel Methane', 'You start eating the Crystel meth with $name, you start seeings some crazy stuff in the alleys so you tell $name your going to head home, befor you left you ate the rest of the shrooms. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 30, 30, 999, 30, 300, 1, 0 ) ;

 

MySQL said:

#1064 - 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 `drugs` VALUES (3, 'Jay', 'him', 'Crystel Methane', 'You start eatin' at line 2

 

CREATE TABLE `drugs` (
 `dID` int(11) NOT NULL auto_increment,
 `dNAME` varchar(255) NOT NULL default 'Some Guy',
 `dSEX` varchar(3) NOT NULL default 'him',
 `dDRUG` varchar(255) NOT NULL default 'Some Drug',
 `dEFFECT` text NOT NULL,
 `energy` int(11) NOT NULL default '0',
 `will` int(11) NOT NULL default '0',
 `brave` int(11) NOT NULL default '0',
 `health` int(11) NOT NULL default '0',
 `dPRICE` int(11) NOT NULL default '0',
 `dQTY` int(11) NOT NULL default '0',
 `dOD` int(11) NOT NULL default '0',
 PRIMARY KEY  (`dID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `drugs` VALUES (1, 'Josh', 'him', 'Cannibis', 'You light up the weed with your lighter and start taking big puffs, you pass it to $name and pass back and forth for a few minutes then you walk home. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 10, 10, 999, 10, 100, 1, 0);
INSERT INTO `drugs` VALUES (2, 'John', 'him', 'Crack', 'You start lining up the crack to snort, you do this a few times with $name then you walk home. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 20, 20, 999, 20, 200, 6, 0)
INSERT INTO `drugs` VALUES (3, 'Jay', 'him', 'Crystel Methane', 'You start eating the Crystel meth with $name, you start seeings some crazy stuff in the alleys so you tell $name your going to head home, befor you left you ate the rest of the shrooms. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 30, 30, 999, 30, 300, 1, 0);
INSERT INTO `drugs` VALUES (4, 'Robert', 'him', 'Heroine', 'You ingect yourself with the syringe full of heroin, you pass it to $name and pass back and forth for a few minutes then you walk home. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 10, 10, 999, 10, 100, 1, 0);
INSERT INTO `drugs` VALUES (5, 'Ross', 'him', 'Ectesy', 'You start the ectasy pils with $name, then you walk home. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 20, 20, 999, 20, 200, 6, 0)
INSERT INTO `drugs` VALUES (6, 'George', 'him', 'LSD', 'You start taking LSD with $name, you start seeings some crazy stuff in the alleys so you tell $name your going to head home, befor you left you ate the rest of the drugs. While walking home you feel all happy and braver, all you want to do is do some illegal activity.', 30, 30, 999, 30, 300, 1, 0);

 

please post a fixed 1 or if you want mail me on msn [email protected]

[Lithium]

Re: Drugs Help

you might want to add a few ; at the end of some INSERT lines you got there...

[EpicFuse]

Re: Drugs Help

+1 for you sir,