Simple update with a fields value increment!!
Hello,
Can anyone Please help me to run this type of command using MySQLi
UPDATE tblName SET hitCount = hitCount + 1 WHERE id = 1
I have tried below options like :
$UpdateQuery->bindColumn("hitCount ", "i", ("+1") , "WA_DEFAULT");
or
$UpdateQuery->bindColumn("hitCount ", "i", ("hitCount" + "1") , "WA_DEFAULT");
or
$UpdateQuery->bindColumn("hitCount ", "i", ('hitCount' + "1") , "WA_DEFAULT");
but no luck. Please help.
Thank you,
Sing