Edit Job Ranks Error

[gazsr123]

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.

[Danny696]

there isnt a space between the WHERE and the 100 :)

[gazsr123]

Hey pal, where do I put the space when I edit a job rank?

Regards,

Gaz.

[Blade Maker]

Put the space before the WHERE

[gazsr123]

There isn't no 'WHERE' because i'm editing the job ranks through the staff panel not on phpmyadmin or any other forms.

[Dominion]

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.

[gazsr123]

Course I knew pal, was just testing you. ;)

Ahaha... Thanks for that guys, you really have helped. :)