[RESOLVED] Simle Update Statement from form vars

[bmarker]

I don't know why I can get this to work with just one value but not with multiple...

This works:

$jobCode = $_POST['jobCode'];

"UPDATE jobs.jobdata SET jobCode = $jobCode WHERE jobdata.jobID = $jobID LIMIT 1;"

This doesn't:

$jobCode = $_POST['jobCode'];
$jobDesc = $_POST['jobDesc'];

"UPDATE jobs.jobdata SET jobCode = $jobCode, jobDesc = $jobDesc, WHERE jobdata.jobID = $jobID LIMIT 1;"

I have traced the variables and they both show up. Why doesn't this update?

[bmarker]

jobDesc = $jobDesc needs to be jobDesc = '$jobDesc' because its a string and the reason it wasn't erroring out on the sql statement was b/c jobCode was an int.