Liste - Points GIS en ajax

[lhc/web/spip_carte_de_sites.git] / inclure / liste_gis.html

diff --git a/inclure/liste_gis.html b/inclure/liste_gis.html
new file mode 100644 (file)
index 0000000..d36fd92
--- /dev/null
+++ b/inclure/liste_gis.html
@@ -0,0 +1,5 @@
+#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.* FROM spip_mots, spip_mots_syndic, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='Ateliers' AND spip_mots_syndic.id_syndic=spip_syndic.id_syndic AND spip_syndic.id_syndic=spip_gis_liens.id_objet AND spip_gis.id_gis=spip_gis_liens.id_gis AND spip_gis_liens.objet='syndic' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}}
+
+<BOUCLE_sql(DATA){source sql,#GET{req_gis}}>
+    <li>#VILLE - #TITRE</li>
+</BOUCLE_sql>
\ No newline at end of file