setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql="UPDATE vsaqtns SET qnatr ='$qnatr', exmtyp ='$exmtyp', dt ='$dt', sbj='$sbj', yr='$yr', questn='$questn', cha='$cha', chb='$chb', chc='$chc', chd='$chd', resp='$resp', soln='$soln', paragT='$paragT', btch='$btch', tps='$tps', qsttus='$qsttus', stMark='$stMark' WHERE pos=". $conn->quote($pos); //$sql="UPDATE vsaqtns SET qnatr ='$qnatr', exmtyp ='$exmtyp', dt ='$dt', sbj='$sbj', yr='$yr', questn='$questn', paragT='$paragT', cha='$cha', chb='$chb', chc='$chc', chd='$chd', resp='$resp', soln='$soln', btch='$btch', tps='$tps', qsttus='$qsttus', stMark='$stMark' WHERE pos=". $conn->quote($pos); //$sql = "Select * FROM vsaqtns WHERE pos="(int)$pos; //$sql = "Select * from vsaqtns WHERE pos=". $conn->quote($pos); //$sql = "UPDATE vsaqtns SET questn=? WHERE pos=?"; // Prepare statement $stmt = $conn->prepare($sql); //$stmt = $conn->exec($sql); // execute the query $stmt->execute(); // echo a message to say the UPDATE succeeded echo $stmt->rowCount() . " record(s) UPDATED successfully"; // " records UPDATED successfully"; $conn = null; } catch(PDOException $e) { echo $sql . "
" . $e->getMessage(); } ?>