POG1 Posted September 25, 2007 Share Posted September 25, 2007 when i try to make a crime on the admin pannel it says this UERY 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 ' 0, '1', 'rdrtd', 'ytdrytrd', 'ytrdytr', 'htrdtrd', 1, 'www', 1)' at line 1 Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( '8484', '1', '((WILL*0.8)/2.5)+(LEVEL/4)', '33', , 0, '1', 'rdrtd', 'ytdrytrd', 'ytrdytr', 'htrdtrd', 1, 'www', 1) how can i fix it? Quote Link to comment Share on other sites More sharing options...
UCC Posted September 25, 2007 Share Posted September 25, 2007 Re: Crimes dont work If I am counting your fields correctly, your input for crimeSUCCESSCRYS does not exist. I would make sure you enter a Zero into that field if it exists. You might also want to add apostrophies around that field in the query. I dont know your code exactly but I'm guessing '{$_POST['crimeSUCCESSCRYS']}' Quote Link to comment Share on other sites More sharing options...
POG1 Posted September 25, 2007 Author Share Posted September 25, 2007 Re: Crimes dont work wouldn't it be easier to delete the crime row and get a new 1 of someone else? Quote Link to comment Share on other sites More sharing options...
UCC Posted September 25, 2007 Share Posted September 25, 2007 Re: Crimes dont work That logic does not compute with me. Why would you go through all that effort when the fix is oh so easy? The whole idea of solving one's problem by getting new code from someone else boggles my mind. 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.