gazsr123 Posted October 30, 2010 Share Posted October 30, 2010 Hi I'd be so grateful if someone could help me solve this problem. Basically when I a job rank on my game I get the error: QUERY 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 'jrID=40' at line 1 Query was UPDATE jobranks SET jrNAME='Captain', jrJOB = 11, jrPAY= 100, jrIQG=100, jrLABOURG=100, jrSTRG=100, jrIQN=100, jrLABOURN=100, jrSTRN=100WHERE jrID=40 it will be great if someone can help. Thanks. Quote Link to comment Share on other sites More sharing options...
Danny696 Posted October 30, 2010 Share Posted October 30, 2010 there isnt a space between the WHERE and the 100 :) Quote Link to comment Share on other sites More sharing options...
gazsr123 Posted October 31, 2010 Author Share Posted October 31, 2010 Hey pal, where do I put the space when I edit a job rank? Regards, Gaz. Quote Link to comment Share on other sites More sharing options...
Blade Maker Posted October 31, 2010 Share Posted October 31, 2010 Put the space before the WHERE Quote Link to comment Share on other sites More sharing options...
gazsr123 Posted November 2, 2010 Author Share Posted November 2, 2010 There isn't no 'WHERE' because i'm editing the job ranks through the staff panel not on phpmyadmin or any other forms. Quote Link to comment Share on other sites More sharing options...
Dominion Posted November 2, 2010 Share Posted November 2, 2010 QUERY 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 'jrID=40' at line 1 Query was UPDATE jobranks SET jrNAME='Captain', jrJOB = 11, jrPAY= 100, jrIQG=100, jrLABOURG=100, jrSTRG=100, jrIQN=100, jrLABOURN=100, jrSTRN=100WHERE jrID=40 they mean- notice this part "jrSTRN=100WHERE jrID=40 " In that query (it's inside the staff_jobs file!) space it out. Quote Link to comment Share on other sites More sharing options...
gazsr123 Posted November 2, 2010 Author Share Posted November 2, 2010 Course I knew pal, was just testing you. ;) Ahaha... Thanks for that guys, you really have helped. :) 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.