"._("operation_defunt"); $tableSelect=DB_PREFIXE."operation_defunt"; $champs=array( "operation_defunt", "operation", "defunt", "defunt_titre", "defunt_nom", "defunt_marital", "defunt_prenom", "defunt_datenaissance", "defunt_datedeces", "defunt_lieudeces", "defunt_nature"); //champs select $sql_defunt="SELECT defunt.defunt, defunt.nature FROM ".DB_PREFIXE."defunt ORDER BY defunt.nature ASC"; $sql_defunt_by_id = "SELECT defunt.defunt, defunt.nature FROM ".DB_PREFIXE."defunt WHERE defunt = "; $sql_defunt_titre="SELECT titre_de_civilite.titre_de_civilite, titre_de_civilite.libelle FROM ".DB_PREFIXE."titre_de_civilite WHERE ((titre_de_civilite.om_validite_debut IS NULL AND (titre_de_civilite.om_validite_fin IS NULL OR titre_de_civilite.om_validite_fin > CURRENT_DATE)) OR (titre_de_civilite.om_validite_debut <= CURRENT_DATE AND (titre_de_civilite.om_validite_fin IS NULL OR titre_de_civilite.om_validite_fin > CURRENT_DATE))) ORDER BY titre_de_civilite.libelle ASC"; $sql_defunt_titre_by_id = "SELECT titre_de_civilite.titre_de_civilite, titre_de_civilite.libelle FROM ".DB_PREFIXE."titre_de_civilite WHERE titre_de_civilite = "; $sql_operation="SELECT operation.operation, operation.numdossier FROM ".DB_PREFIXE."operation ORDER BY operation.numdossier ASC"; $sql_operation_by_id = "SELECT operation.operation, operation.numdossier FROM ".DB_PREFIXE."operation WHERE operation = "; ?>