$stmt = $dbh->prepare("
UPDATE entry SET 
voms=:voms,
counter=:counter,
session=:session, 
principal=:principal
WHERE formno=:formno " );
									
$stmt->bindparam(':voms', $voms);
$stmt->bindparam(':counter', $counters);
$stmt->bindparam(':session', $sessn);
$stmt->bindparam(':principal', $voms);
$stmt->bindparam(':formno', $idvalue);
$stmt->execute();

After been adviced to switched to PDO/MYSQLI, i settled for PDO because of its flexibility over various database engine. However, looking at the above, i have been scratching my head since morning to get it to work effectively with little success.

My problem is that it shows its updating the sqlite database but on checking the database, it does not update the database.

Please am i missing anything in the code above, what am i doing wrong. Thanks for your guidance

turn on pdo 's error exception
http://php.net/manual/en/pdo.setattribute.php

thanks jregs

i was not updating based on id but on the form hence the continous problem.

resolved it