"._("demandeur"); $tableSelect=DB_PREFIXE."demandeur"; $champs=array( "demandeur", "type_demandeur", "qualite", "particulier_nom", "particulier_prenom", "particulier_date_naissance", "particulier_commune_naissance", "particulier_departement_naissance", "personne_morale_denomination", "personne_morale_raison_sociale", "personne_morale_siret", "personne_morale_categorie_juridique", "personne_morale_nom", "personne_morale_prenom", "numero", "voie", "complement", "lieu_dit", "localite", "code_postal", "bp", "cedex", "pays", "division_territoriale", "telephone_fixe", "telephone_mobile", "indicatif", "courriel", "notification", "frequent", "particulier_civilite", "personne_morale_civilite", "fax"); //champs select $sql_particulier_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_particulier_civilite_by_id = "SELECT civilite.civilite, civilite.libelle FROM ".DB_PREFIXE."civilite WHERE civilite = ''"; $sql_personne_morale_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_personne_morale_civilite_by_id = "SELECT civilite.civilite, civilite.libelle FROM ".DB_PREFIXE."civilite WHERE civilite = ''"; ?>