[V2] Edit Jobs Error...

[KDawg08]

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=2' at line 1

Query was UPDATE jobranks SET jrNAME='Brakes Tech', jrJOB = 1, jrPAY= 400, jrIQG=10, jrLABOURG=10, jrSTRG=8, jrIQN=100, jrLABOURN=150, jrSTRN=220WHERE jrID=2

any idea why? i've editted NOTHING in the scripts for jobs etc.

[bocco]

Re: [V2] Edit Jobs Error...

well this is a very simple fix

i know this is an late update but i figured if someone else had this issue i would let you know

see where it is "222where jrID=2"

well find find this

$db->query("UPDATE jobs SET jNAME='{$_POST['jNAME']}', jDESC='{$_POST['jDESC']}', jOWNER='{$_POST['jOWNER']}', jFIRST={$_POST['jFIRST']}WHERE jID={$_POST['jID']}");

 

and replace it with this

$db->query("UPDATE jobs SET jNAME='{$_POST['jNAME']}', jDESC='{$_POST['jDESC']}', jOWNER='{$_POST['jOWNER']}', jFIRST={$_POST['jFIRST']} WHERE jID={$_POST['jID']}");