[問題]sql 問題

[楓兒]

我想 update 一個field , 佢係 varchar type.

$newposition = 'yyy';

$sql = "update x_table set newposition = $newposition ";

結果就係唔得

但我

$sql = "update x_table set newposition = 'xxx' ";
就無問題, 請問點解 一用variable 就死呢?

[Mac]

可以用普通話嗎？看不懂香港用語

~Mac

[ethan]

我想 update 一個field , 佢係 varchar type.

$newposition = 'yyy';

$sql = "update x_table set newposition = $newposition ";

結果就係唔得

但我

$sql = "update x_table set newposition = 'xxx' ";
就無問題, 請問點解 一用variable 就死呢?

$sql = "update x_table set newposition = '$newposition' ";

字串應該用引號括起來，就是這個原因