setQuery("SELECT * FROM contacts WHERE contacts.companyname='$compname'"); $searchctdetail->execute(); if (!empty($searchctdetail->getColumnVal("companyname"))) { $companynamet=$searchctdetail->getColumnVal("companyname"); } else { $companynamet=""; } if (!empty($searchctdetail->getColumnVal("piva"))) { $piva=$searchctdetail->getColumnVal("piva"); } else { $piva=""; } if (!empty($searchctdetail->getColumnVal("address"))) { $address=$searchctdetail->getColumnVal("address"); } else { $address=""; } if (!empty($searchctdetail->getColumnVal("city"))) { $city=$searchctdetail->getColumnVal("city"); } else { $city=""; } if (!empty($searchctdetail->getColumnVal("cap"))) { $cap=$searchctdetail->getColumnVal("cap"); } else { $cap=""; } if (!empty($searchctdetail->getColumnVal("country"))) { $country=$searchctdetail->getColumnVal("country"); } else { $country=""; } if (!empty($searchctdetail->getColumnVal("telephone"))) { $telephone=$searchctdetail->getColumnVal("telephone"); } else { $telephone=""; } if (!empty($searchctdetail->getColumnVal("email"))) { $email=$searchctdetail->getColumnVal("email"); } else { $email=""; } if (!empty($searchctdetail->getColumnVal("contactname"))) { $contactname=$searchctdetail->getColumnVal("contactname"); } else { $contactname=""; } if (!empty($searchctdetail->getColumnVal("contactsurname"))) { $contactsurname=$searchctdetail->getColumnVal("contactsurname"); } else { $contactsurname=""; } $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "contacts"; $UpdateQuery->bindColumn("companyname", "s", "$companynamet", "WA_DEFAULT"); $UpdateQuery->bindColumn("piva", "s", "$piva", "WA_DEFAULT"); $UpdateQuery->bindColumn("address", "s", "$address", "WA_DEFAULT"); $UpdateQuery->bindColumn("city", "s", "$city", "WA_DEFAULT"); $UpdateQuery->bindColumn("cap", "s", "$cap", "WA_DEFAULT"); $UpdateQuery->bindColumn("country", "s", "$country", "WA_DEFAULT"); $UpdateQuery->bindColumn("telephone", "s", "$telephone", "WA_DEFAULT"); $UpdateQuery->bindColumn("email", "s", "$email", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactname", "s", "$contactname", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactsurname", "s", "$contactsurname", "WA_DEFAULT"); $UpdateQuery->bindColumn("companyid", "i", "$companyid", "WA_DEFAULT"); $UpdateQuery->addFilter("idcontacts", "=", "i", "".($idcontacts) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } ?> Action = "update"; $UpdateQuery->Table = "contacts"; $UpdateQuery->bindColumn("companyname", "s", "$companynamet", "WA_DEFAULT"); $UpdateQuery->bindColumn("piva", "s", "$piva", "WA_DEFAULT"); $UpdateQuery->bindColumn("address", "s", "$address", "WA_DEFAULT"); $UpdateQuery->bindColumn("city", "s", "$city", "WA_DEFAULT"); $UpdateQuery->bindColumn("cap", "s", "$cap", "WA_DEFAULT"); $UpdateQuery->bindColumn("country", "s", "$country", "WA_DEFAULT"); $UpdateQuery->bindColumn("telephone", "s", "$telephone", "WA_DEFAULT"); $UpdateQuery->bindColumn("email", "s", "$email", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactname", "s", "$contactname", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactsurname", "s", "$contactsurname", "WA_DEFAULT"); $UpdateQuery->bindColumn("companyid", "i", "$companyid", "WA_DEFAULT"); $UpdateQuery->addFilter("idcontacts", "=", "i", "".($idcontacts) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } ?> setQuery("SELECT * FROM company WHERE company.idcompany='$idcompany'"); $contactsdet->execute(); if (!is_null($contactsdet->getColumnVal("companyname_company"))) { $companynamet=$contactsdet->getColumnVal("companyname_company"); } else { $companynamet=""; } if (!is_null($contactsdet->getColumnVal("piva_company"))) { $piva=$contactsdet->getColumnVal("piva_company"); } else { $piva=""; } if (!is_null($contactsdet->getColumnVal("address_company"))) { $address=$contactsdet->getColumnVal("address_company"); } else { $address=""; } if (!is_null($contactsdet->getColumnVal("city_company"))) { $city=$contactsdet->getColumnVal("city_company"); } else { $city=""; } if (!is_null($contactsdet->getColumnVal("zip_company"))) { $cap=$contactsdet->getColumnVal("zip_company"); } else { $cap=""; } if (!is_null($contactsdet->getColumnVal("country_company"))) { $country=$contactsdet->getColumnVal("country_company"); } else { $country=""; } if (!is_null($contactsdet->getColumnVal("telephone_company"))) { $telephone=$contactsdet->getColumnVal("telephone_company"); } else { $telephone=""; } if (!is_null($contactsdet->getColumnVal("email_company"))) { $email=$contactsdet->getColumnVal("email_company"); } else { $email=""; } if (!is_null($contactsdet->getColumnVal("maincontactname_company"))) { $contactname=$contactsdet->getColumnVal("maincontactname_company"); } else { $contactname=""; } if (!is_null($contactsdet->getColumnVal("maincontactsurname_company"))) { $contactsurname=$contactsdet->getColumnVal("maincontactsurname_company"); } else { $contactsurname=""; } if (!is_null($idcompany)) { $companyid=$idcompany; } else { $companyid=""; } $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "contacts"; $UpdateQuery->bindColumn("companyname", "s", "$companynamet", "WA_DEFAULT"); $UpdateQuery->bindColumn("piva", "s", "$piva", "WA_DEFAULT"); $UpdateQuery->bindColumn("address", "s", "$address", "WA_DEFAULT"); $UpdateQuery->bindColumn("city", "s", "$city", "WA_DEFAULT"); $UpdateQuery->bindColumn("cap", "s", "$cap", "WA_DEFAULT"); $UpdateQuery->bindColumn("country", "s", "$country", "WA_DEFAULT"); $UpdateQuery->bindColumn("telephone", "s", "$telephone", "WA_DEFAULT"); $UpdateQuery->bindColumn("email", "s", "$email", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactname", "s", "$contactname", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactsurname", "s", "$contactsurname", "WA_DEFAULT"); $UpdateQuery->bindColumn("companyid", "i", "$companyid", "WA_DEFAULT"); $UpdateQuery->addFilter("idcontacts", "=", "i", "".($idcontacts) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } ?> setQuery("SELECT * FROM contacts WHERE contacts.idtrf='$idtrf' AND contacts.kindofcontacts='$kindcontactscopy'"); $contactsdet->execute(); if (!is_null($contactsdet->getColumnVal("companyname"))) { $companynamet=$contactsdet->getColumnVal("companyname"); } else { $companynamet=""; } if (!is_null($contactsdet->getColumnVal("piva"))) { $piva=$contactsdet->getColumnVal("piva"); } else { $piva=""; } if (!is_null($contactsdet->getColumnVal("address"))) { $address=$contactsdet->getColumnVal("address"); } else { $address=""; } if (!is_null($contactsdet->getColumnVal("city"))) { $city=$contactsdet->getColumnVal("city"); } else { $city=""; } if (!is_null($contactsdet->getColumnVal("cap"))) { $cap=$contactsdet->getColumnVal("cap"); } else { $cap=""; } if (!is_null($contactsdet->getColumnVal("country"))) { $country=$contactsdet->getColumnVal("country"); } else { $country=""; } if (!is_null($contactsdet->getColumnVal("telephone"))) { $telephone=$contactsdet->getColumnVal("telephone"); } else { $telephone=""; } if (!is_null($contactsdet->getColumnVal("email"))) { $email=$contactsdet->getColumnVal("email"); } else { $email=""; } if (!is_null($contactsdet->getColumnVal("contactname"))) { $contactname=$contactsdet->getColumnVal("contactname"); } else { $contactname=""; } if (!is_null($contactsdet->getColumnVal("contactsurname"))) { $contactsurname=$contactsdet->getColumnVal("contactsurname"); } else { $contactsurname=""; } $companyid=0; $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "contacts"; $UpdateQuery->bindColumn("companyname", "s", "$companynamet", "WA_DEFAULT"); $UpdateQuery->bindColumn("piva", "s", "$piva", "WA_DEFAULT"); $UpdateQuery->bindColumn("address", "s", "$address", "WA_DEFAULT"); $UpdateQuery->bindColumn("city", "s", "$city", "WA_DEFAULT"); $UpdateQuery->bindColumn("cap", "s", "$cap", "WA_DEFAULT"); $UpdateQuery->bindColumn("country", "s", "$country", "WA_DEFAULT"); $UpdateQuery->bindColumn("telephone", "s", "$telephone", "WA_DEFAULT"); $UpdateQuery->bindColumn("email", "s", "$email", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactname", "s", "$contactname", "WA_DEFAULT"); $UpdateQuery->bindColumn("contactsurname", "s", "$contactsurname", "WA_DEFAULT"); $UpdateQuery->bindColumn("companyid", "i", "$companyid", "WA_DEFAULT"); $UpdateQuery->addFilter("idcontacts", "=", "i", "".($idcontacts) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } if ($kindcontacts=="certificatetotest") { $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "`trf-details`"; $UpdateQuery->bindColumn("certotherclient", "s", "Y", "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(); ?> getColumnVal("idcertification"); $idcert=$trfnumberfinal->getColumnVal("idcertification"); ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute(); ?> setQuery("SELECT * FROM contacts WHERE contacts.idtrf='$idtrf'"); $contactdatacheck->execute(); $contactlist=array(); ?> atEnd()) { $wa_startindex = $contactdatacheck->Index; ?> getColumnVal("kindofcontacts"); ?> moveNext(); } $contactdatacheck->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>