mySQL error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

mySQL error

Post by psychotomus »

Heres the error.

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 ' VALUES ('Test', 'Cockatrice.jpg', '11','22', '33','44', '55', '66','7', '8','Te' at line 1

The Code:

Code: Select all

mysql_query ("INSERT INTO Naruto_Monsters(MonsterName, MonsterFileName, Level, Health, Chakra, Defense, Attack, ChakraPower, ChakraResistance, ChakraSpellPower, SpellName, Chakra), VALUES ('$MonsterName', '$MonsterFileName', '$Level','$Health', '$Chakra','$Defense', '$Attack', '$ChakraPower','$ChakraResistance', '$ChakraSpellPower','$SpellName','$ChakraNeeded')") or die(mysql_error());
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

Post by psychotomus »

nevermind found it. to many ,
Post Reply