[SOLVED] error in SQL syntax but where it all looks fine to me

insert into skills (Account, Name, Alchemy, Blacksmithing, Bowcraft, Carpentry, Cooking, Fishing, Healing, Herding, Lockpicking, Lumberjacking, Magery, Meditation, Mining, Musicianship, Removetrap, MagicResistance, Snooping, Stealing, Stealth, Tailoring, Tinkering, Veterinary, Str, Dex, Int, Level, Exp) VALUES ('<account>', '<NAME>', '<Alchemy>', '<Blacksmithing>', '<Bowcraft>', '<Carpentry>', '<Cooking>', '<Fishing>', '<Healing>', '<Herding>', '<Lockpicking>', '<Lumberjacking>', '<Magery>', '<Meditation>', '<Mining>', '<Musicianship>', '<Removetrap>', '<MagicResistance>', '<Snooping>', '<Stealing>', '<Stealth>', '<Tailoring>', '<Tinkering>', '<Veterinary>', '<str>', '<dex>', '<int>', '<eval <tag0.Level>>', '<eval <tag0.tix>>');"


ERROR:MySQL query "insert into skills (Account, Name, Alchemy, Blacksmithing, Bowcraft, Carpentry, Cooking, Fishing, Healing, Herding, Lockpicking, Lumberjacking, Magery, Meditation, Mining, Musicianship, Removetrap, MagicResistance, Snooping, Stealing, Stealth, Tailoring, Tinkering, Veterinary, Str, Dex, Int, Level, Exp) VALUES ('drewwales', 'Anderson', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.7', '30.0', '30.0', '0.0', '400.0', '400.0', '30.0', '30.0', '30.0', '30.0', '30.0', '30.0', '400', '200', '100', '89', '9');" failed due to "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 'Int, Level, Exp) VALUES ('drewwales', 'Anderson', '30.0', '30.0', '30.0', '30.0'' at line 1"

where is the error it all looks fine to me

Solved

Nice one! May i ask what <Removetrap> things like that are??

__________________
Marc
Staff Manager - Webforumz.com

Want to be a moderator? PM me.

I think it is the value that will be replacing the particular field in the database. In asp it will be like this:

Code: Select all

'" & Removetrap & "'