did as you said but the update still isnt working
<?php require_once('../../Connections/XtremBANK_i.php'); ?>
<?php require_once('../../webassist/mysqli/rsobj.php'); ?>
<?php require_once('../../webassist/mysqli/queryobj.php'); ?>
<?php
$rsChangePassword = new WA_MySQLi_RS("rsChangePassword",$XtremBANK_i,1);
$rsChangePassword->setQuery("SELECT * FROM customer WHERE account_no = ?");
$rsChangePassword->bindParam("i", "".$_SESSION['account_no'] ."", "-1"); //colname
$rsChangePassword->execute();
?>
<?php
if (isset($_POST['currentPassword']) != $rsChangePassword->getColumnVal("password")) {
header('Location:ChangePassword.php?change=unsuccessful');
exit();
}
?>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$UpdateQuery = new WA_MySQLi_Query($XtremBANK_i);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "customer";
$UpdateQuery->bindColumn("password", "s", "".((isset($_POST["confirmPassword"]))?$_POST["confirmPassword"]:"") ."", "WA_DEFAULT");
$UpdateQuery->addFilter("customer_id", "=", "i", "".($rsChangePassword->getColumnVal("password")) ."");
$UpdateQuery->execute();
$UpdateGoTo = "ChangePassword.php?change=successful";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>