Action = "insert"; $InsertQuery->Table = "wheretrfstep"; $InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("code", "i", "$code", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); } // update trf details` if (isset($_POST["optionform"])) { $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "`trf-details`"; $UpdateQuery->bindColumn("languagereport", "s", "$reportlanguage", "WA_DEFAULT"); $UpdateQuery->bindColumn("languagecertificate", "s", "$certificatelanguage", "WA_DEFAULT"); $UpdateQuery->bindColumn("contacttrfname", "s", "$contactsendmail", "WA_DEFAULT"); $UpdateQuery->bindColumn("emailtrfname", "s", "$emailsendmail", "WA_DEFAULT"); $UpdateQuery->bindColumn("ukcacert", "s", "$ukcacert", "WA_DEFAULT"); $UpdateQuery->bindColumn("surveillanceselectoption", "s", "$surveillanceselectoption", "WA_DEFAULT"); $UpdateQuery->addFilter("idtrfdetails", "=", "i", "" . ($idtrf) . ""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : ""; $UpdateQuery->redirect($UpdateGoTo); } ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrf'"); $trfnumberfinal->execute(); $idcertn = $trfnumberfinal->getColumnVal("idcertification"); $otherclient = $trfnumberfinal->getColumnVal("otherclient"); $idarticletype = $trfnumberfinal->getColumnVal("idarticletype"); $revcs = $trfnumberfinal->getColumnVal("revcs"); ?> getColumnVal("idcertification") ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute(); ?> setQuery("SELECT * FROM chemicalagent ORDER BY chemicalagent.name_chemicalagent"); $chemicalagentlist->execute(); ?>