[RESOLVED] Check my syntax please?

[dapuxter]

I'm getting a syntax error from this update statement, and not sure why. Would appreciate any help, thanks!

$sql = mysql_query ("UPDATE `outage` SET `date` = $outagedate, `outagetype`=$outagetype, `mtcplant`=$mtcplant, `city`=$outagecity, `node`=$outagenode, `services`=$services, `custcount`=$custcount, `cbs`=$cbs, 
`impact`=$impact, `desc`=$desc, `status`=$status WHERE ID=$id");

I've tried with and without backticks, and get the same error. Hoping its something simple that I'm overlooking.

[NogDog]

I suspect the problem is that for any of the values you are assigning, they must be quoted if they are strings, e.g.: desc=$desc would need to be desc='$desc'.

To help with debugging, I'd suggest the following pattern to help find the problem:

$query = "SELECT blah blah blah . . .";
$result = mysql_query($query) or die("Query failed ($query) - " . mysql_error());

[laserlight]

Perhaps your values are strings that need to be quoted?

[dapuxter]

It was that they needed to be quoted, but also something with the value "desc". It didn't work when not backticked, but when backticked it does. So its working now, thanks!

[NogDog]

"desc" is a reserved word (used with "order by", for instance).