sql query not running in php, how to fix error?

Question

PHP

There is a sql query in php:

$sql 'UPDATE `_spi`
SET `w_st`=`w_t`+`w_s`+`w_z`+`w_p`
CASE WHEN `p_m` =  'IV'
THEN `w_t`+`w_s`
ELSE 0
END';

But when I run it I get an error:

PHP Parse error: syntax error, unexpected 'IV' (T_STRING)

I just don't know what's wrong? Tell me please.

Answer 1

$sql = "UPDATE `_spi`
SET `w_st`=`w_t`+`w_s`+`w_z`+`w_p`
CASE WHEN `p_m` =  'IV'
THEN `w_t`+`w_s`
ELSE 0
END";

Answer 2

The quotes need to be escaped.
And it looks like the sign (+ etc.) forgot to put before CASE

$sql 'UPDATE `_spi`
SET `w_st`=`w_t`+`w_s`+`w_z`+`w_p` + CASE WHEN `p_m` =  \'IV\' THEN `w_t`+`w_s` ELSE 0 END';