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); } ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrf'"); $trfnumberfinal->execute(); $idarticletype = $trfnumberfinal->getColumnVal("idarticletype"); $idcertn = $trfnumberfinal->getColumnVal("idcertification"); ?> getColumnVal("idcertification") ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute(); ?> setQuery("SELECT * FROM chemicalagent ORDER BY chemicalagent.name_chemicalagent"); $chemicalagentlist->execute(); ?> setQuery("SELECT * FROM trfchemicalagent WHERE trfchemicalagent.idtrf='$idtrf' AND trfchemicalagent.idchemicalagent='$addchem'"); $checkchemical->execute(); if (empty($checkchemical->getColumnVal("idtrfchemicalagent"))) { $InsertQuery = new WA_MySQLi_Query($cmctrfdb); $InsertQuery->Action = "insert"; $InsertQuery->Table = "trfchemicalagent"; $InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("idchemicalagent", "i", "$addchem", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); } } ?> setQuery("SELECT * FROM trfchemicalagent LEFT JOIN chemicalagent ON trfchemicalagent.idchemicalagent=chemicalagent.idchemicalagent WHERE trfchemicalagent.idtrf='$idtrf'"); $chemagentselected->execute(); ?> <?php echo $titlepage; ?>
  2. Starter

80%

">

atEnd()) { $wa_startindex = $chemagentselected->Index; ?> moveNext(); } $chemagentselected->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
getColumnVal("name_chemicalagent")); ?> &idtrf=">