我想添加用户输入值（$ itm_sld）+现有值（itm_sld）

I want to add user input value ($itm_sld) + Existing value itm_sld I use this code

我想添加用户输入值($ itm_sld)+现有值itm_sld我使用此代码

<?php
$sql="UPDATE itm_tot 
SET itm_sld = itm_sld + '$itm_sld'
WHERE itm_no='$itm_no'"; ?>

But the new value is UPDATED by itm_sld = itm_sld + (itm_sld + '$itm_sld')

但是新值是由itm_sld = itm_sld +(itm_sld +'$ itm_sld')更新的

What should i do to update itm_sld by (itm_sld + '$itm_sld')

我该怎么做才能通过(itm_sld +'$ itm_sld')更新itm_sld

Thanks....

1 个解决方案

#1

Check CONCAT() method for string concatenation.

检查字符串连接的CONCAT()方法。