Editing job ranks error

[PrimeSuspect]

Hello ;

i get this error when i try to edit a job rank..

QUERY ERROR:

Query was UPDATE jobranks SET jrNAME='Nurse', jrJOB = 1, jrPAY= 1000, jrIQG=15, jrLABOURG=30, jrSTRG=18, jrIQN=1000, jrLABOURN=1500, jrSTRN=1200WHERE jrID=3

I only try to change name of the job rank.For example ; Chancing Nurse as Hemsire

[BoGFx]

Hello ;

i get this error when i try to edit a job rank..

QUERY ERROR:

Query was UPDATE jobranks SET jrNAME='Nurse', jrJOB = 1, jrPAY= 1000, jrIQG=15, jrLABOURG=30, jrSTRG=18, jrIQN=1000, jrLABOURN=1500, jrSTRN=1200WHERE jrID=3

I only try to change name of the job rank.For example ; Chancing Nurse as Hemsire

Shouldn't there be a space between 1200 and WHERE

[Matthew]

Do you have all the SQL's for that?

[PrimeSuspect]

Hello ;

i get this error when i try to edit a job rank..

QUERY ERROR:

Query was UPDATE jobranks SET jrNAME='Nurse', jrJOB = 1, jrPAY= 1000, jrIQG=15, jrLABOURG=30, jrSTRG=18, jrIQN=1000, jrLABOURN=1500, jrSTRN=1200WHERE jrID=3

I only try to change name of the job rank.For example ; Chancing Nurse as Hemsire

Shouldn't there be a space between 1200 and WHERE

i dunno..are you sure ?

Edit : I checked the codes but i thnk its not about this.. This is the error what i have..

[PrimeSuspect]

Hello ;

i get this error when i try to edit a job rank..

QUERY ERROR:

Query was UPDATE jobranks SET jrNAME='Nurse', jrJOB = 1, jrPAY= 1000, jrIQG=15, jrLABOURG=30, jrSTRG=18, jrIQN=1000, jrLABOURN=1500, jrSTRN=1200WHERE jrID=3

I only try to change name of the job rank.For example ; Chancing Nurse as Hemsire

Shouldn't there be a space between 1200 and WHERE

Do you have all the SQL's for that?

Yes.. I can easyly change it from the sql table (jobrank).But when i try to change it from the staff panel i get tht error..

[PrimeSuspect]

Hello ;

i get this error when i try to edit a job rank..

QUERY ERROR:

Query was UPDATE jobranks SET jrNAME='Nurse', jrJOB = 1, jrPAY= 1000, jrIQG=15, jrLABOURG=30, jrSTRG=18, jrIQN=1000, jrLABOURN=1500, jrSTRN=1200WHERE jrID=3

I only try to change name of the job rank.For example ; Chancing Nurse as Hemsire

Shouldn't there be a space between 1200 and WHERE

i dunno..are you sure ?

Edit : I checked the codes but i thnk its not about this.. This is the error what i have..

I solved the problem..You were right , i checked again staffjob.php and put a space between 1200 and WHERE and solved...

Thank You...