Essentially I'm just trying to increment a value in columnA
by 1, but I want to do so with a parameterized mysqli query. The existing value may be null, blank or a number, but if it is the former two, then the query should just treat it as 0 and increment it by 1. The example here does so without a parameter.
My existing code is here - stuck on the bind_param step:
$prepare = $this -> db -> prepare("UPDATE userinfo SET idarray = ?, currentkey = ? WHERE id = ?");
$prepare -> bind_param('sii', serialize($numbers), currentkey + 1, $ID);
$prepare -> execute();
if ($prepare -> errno)
{
echo $prepare -> error;
}
$prepare -> close();