"._("signataire_arrete"); $tableSelect=DB_PREFIXE."signataire_arrete"; $champs=array( "signataire_arrete", "civilite", "nom", "prenom", "qualite", "signature", "defaut", "om_validite_debut", "om_validite_fin"); //champs select $sql_civilite="SELECT civilite.civilite, civilite.libelle FROM ".DB_PREFIXE."civilite WHERE ((civilite.om_validite_debut IS NULL AND (civilite.om_validite_fin IS NULL OR civilite.om_validite_fin > CURRENT_DATE)) OR (civilite.om_validite_debut <= CURRENT_DATE AND (civilite.om_validite_fin IS NULL OR civilite.om_validite_fin > CURRENT_DATE))) ORDER BY civilite.libelle ASC"; $sql_civilite_by_id = "SELECT civilite.civilite, civilite.libelle FROM ".DB_PREFIXE."civilite WHERE civilite = ''"; ?>