setQuery("SELECT * FROM article_type ORDER BY article_type.name_articletype"); $articletypelist->execute();?> setQuery("SELECT article_characteristic.name_articlecharacteristic, article_characteristic.name_articlecharacteristic_eng, article_type.name_articletype, article_characteristic.idarticletype AS arttypeid FROM article_characteristic LEFT JOIN article_type ON article_type.idarticletype=article_characteristic.idarticletype WHERE article_characteristic.idarticlecharacteristic='$idarticlecharacteristic'"); $artcharact->execute(); ?> Action = "update"; $UpdateQuery->Table = "standards"; $UpdateQuery->bindColumn("fmidstandards", "i", "".((isset($_POST["fmcode"]))?$_POST["fmcode"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("standardname", "s", "".((isset($_POST["itastdname"]))?$_POST["itastdname"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("standardname_eng", "s", "".((isset($_POST["engstdname"]))?$_POST["engstdname"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("standardcode", "s", "".((isset($_POST["standardcode"]))?$_POST["standardcode"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("idarticletype", "i", "".((isset($_POST["idarticletype"]))?$_POST["idarticletype"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("idarticlecharacteristic", "i", "".((isset($_POST["articlecharact"]))?$_POST["articlecharact"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("iddpicategory", "i", "".((isset($_POST["categorydpi"]))?$_POST["categorydpi"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("virusset", "s", "".((isset($_POST["virusprotection"]))?$_POST["virusprotection"]:"") ."", "WA_DEFAULT"); $UpdateQuery->bindColumn("chemicalsset", "s", "".((isset($_POST["chemicalagent"]))?$_POST["chemicalagent"]:"") ."", "WA_DEFAULT"); $UpdateQuery->addFilter("idstandards", "=", "i", "".($idstandards) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } ?> TRF CIMAC
  1. TRF
  2. Starter

EDIT CHARACTERISTIC

" id="name_articlecharacteristic" name="name_articlecharacteristic">
" id="name_articlecharacteristic_eng" name="name_articlecharacteristic_eng">