setQuery("SELECT * FROM `trf-details` LEFT JOIN article_type ON `trf-details`.idarticletype=article_type.idarticletype LEFT JOIN certificationtype ON certificationtype.idcertificationtype=`trf-details`.idcertification WHERE `trf-details`.iduser='$iduserlogin' AND `trf-details`.signedon IS NOT NULL or `trf-details`.signedon <>'' ORDER BY `trf-details`.trfnumber"); $archivetrflist->execute();?> setQuery("SELECT * FROM `trf-details` LEFT JOIN article_type ON `trf-details`.idarticletype=article_type.idarticletype LEFT JOIN certificationtype ON certificationtype.idcertificationtype=`trf-details`.idcertification WHERE `trf-details`.iduser='$iduserlogin' AND `trf-details`.signedon IS NULL or `trf-details`.signedon ='' ORDER BY `trf-details`.trfnumber"); $drafttrf->execute(); ?>