setQuery("SELECT * FROM article_type ORDER BY article_type.name_articletype");
$articletypelist->execute();?>
setQuery("SELECT protectioncategory.name_protectioncategory, protectioncategory.name_protectioncategory_en, article_type.name_articletype, protectioncategory.idarticletype AS arttypeid FROM protectioncategory LEFT JOIN article_type ON article_type.idarticletype=protectioncategory.idarticletype WHERE protectioncategory.idprotectioncategory='$idprotectioncategory'");
$protcatrecord->execute();
?>
TRF CIMAC