"._("emplacement_archive"); $tableSelect=DB_PREFIXE."emplacement_archive"; $champs=array( "emplacement", "nature", "numero", "complement", "voie", "numerocadastre", "famille", "numeroacte", "datevente", "terme", "duree", "dateterme", "nombreplace", "placeoccupe", "superficie", "placeconstat", "dateconstat", "observation", "plans", "positionx", "positiony", "photo", "libre", "sepulturetype"); //champs select $sql_sepulturetype="SELECT sepulture_type.sepulture_type, sepulture_type.libelle FROM ".DB_PREFIXE."sepulture_type WHERE ((sepulture_type.om_validite_debut IS NULL AND (sepulture_type.om_validite_fin IS NULL OR sepulture_type.om_validite_fin > CURRENT_DATE)) OR (sepulture_type.om_validite_debut <= CURRENT_DATE AND (sepulture_type.om_validite_fin IS NULL OR sepulture_type.om_validite_fin > CURRENT_DATE))) ORDER BY sepulture_type.libelle ASC"; $sql_sepulturetype_by_id = "SELECT sepulture_type.sepulture_type, sepulture_type.libelle FROM ".DB_PREFIXE."sepulture_type WHERE sepulture_type = "; ?>