"._("zone"); $tableSelect=DB_PREFIXE."zone"; $champs=array( "zone", "cimetiere", "zonetype", "zonelib", "geom"); //champs select $sql_cimetiere="SELECT cimetiere.cimetiere, cimetiere.cimetierelib FROM ".DB_PREFIXE."cimetiere ORDER BY cimetiere.cimetierelib ASC"; $sql_cimetiere_by_id = "SELECT cimetiere.cimetiere, cimetiere.cimetierelib FROM ".DB_PREFIXE."cimetiere WHERE cimetiere = "; $sql_zonetype="SELECT zone_type.zone_type, zone_type.libelle FROM ".DB_PREFIXE."zone_type WHERE ((zone_type.om_validite_debut IS NULL AND (zone_type.om_validite_fin IS NULL OR zone_type.om_validite_fin > CURRENT_DATE)) OR (zone_type.om_validite_debut <= CURRENT_DATE AND (zone_type.om_validite_fin IS NULL OR zone_type.om_validite_fin > CURRENT_DATE))) ORDER BY zone_type.libelle ASC"; $sql_zonetype_by_id = "SELECT zone_type.zone_type, zone_type.libelle FROM ".DB_PREFIXE."zone_type WHERE zone_type = "; ?>