here I use
the value of item_num in mysql become "0"
it Executes: (please note red part)
UPDATE `lb_user` SET item_num = 'item_num+1' WHERE `id` = '1'
but when I use the follow code
UPDATE `lb_user` SET item_num = item_num+1 WHERE `id` = '1'
it works well.
I guess the third param($escape) might be a bug. please test, thanks.
PHP Code:
$db->table('user')->set('item_num','item_num+1',false)->where('id',1)->update();
it Executes: (please note red part)
UPDATE `lb_user` SET item_num = 'item_num+1' WHERE `id` = '1'
but when I use the follow code
UPDATE `lb_user` SET item_num = item_num+1 WHERE `id` = '1'
it works well.
I guess the third param($escape) might be a bug. please test, thanks.