"._("proprietaire"); $tableSelect=DB_PREFIXE."proprietaire"; $champs=array( "proprietaire", "nom", "prenom", "adresse1", "adresse2", "cp", "ville", "civilite"); //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 = ''"; ?>