"._("travaux_archive"); $tableSelect=DB_PREFIXE."travaux_archive"; $champs=array( "travaux", "entreprise", "emplacement", "datedebinter", "datefininter", "observation", "naturedemandeur", "naturetravaux"); //champs select $sql_naturetravaux="SELECT travaux_nature.travaux_nature, travaux_nature.libelle FROM ".DB_PREFIXE."travaux_nature WHERE ((travaux_nature.om_validite_debut IS NULL AND (travaux_nature.om_validite_fin IS NULL OR travaux_nature.om_validite_fin > CURRENT_DATE)) OR (travaux_nature.om_validite_debut <= CURRENT_DATE AND (travaux_nature.om_validite_fin IS NULL OR travaux_nature.om_validite_fin > CURRENT_DATE))) ORDER BY travaux_nature.libelle ASC"; $sql_naturetravaux_by_id = "SELECT travaux_nature.travaux_nature, travaux_nature.libelle FROM ".DB_PREFIXE."travaux_nature WHERE travaux_nature = "; ?>