"._("emplacement"); $tableSelect=DB_PREFIXE."emplacement"; $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", "daterenouvellement", "renouvellementconcession", "typeconcession", "temp1", "temp2", "temp3", "temp4", "temp5", "videsanitaire", "semelle", "etatsemelle", "monument", "etatmonument", "largeur", "profondeur", "abandon", "date_abandon", "dateacte", "geom"); //champs select $sql_plans="SELECT plans.plans, plans.planslib FROM ".DB_PREFIXE."plans ORDER BY plans.planslib ASC"; $sql_plans_by_id = "SELECT plans.plans, plans.planslib FROM ".DB_PREFIXE."plans WHERE plans = "; $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 = "; $sql_voie="SELECT voie.voie, voie.zone FROM ".DB_PREFIXE."voie ORDER BY voie.zone ASC"; $sql_voie_by_id = "SELECT voie.voie, voie.zone FROM ".DB_PREFIXE."voie WHERE voie = "; ?>