[Mapbender-commits] r1120 - trunk/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2007-02-13 05:49:25 -0500 (Tue, 13 Feb 2007)
New Revision: 1120

Modified:
   trunk/mapbender/http/php/mod_exportGUI.php
Log:
statements ordered

elements by element id
element vars by element id and var_name

Modified: trunk/mapbender/http/php/mod_exportGUI.php
===================================================================
--- trunk/mapbender/http/php/mod_exportGUI.php	2007-02-13 09:11:47 UTC (rev 1119)
+++ trunk/mapbender/http/php/mod_exportGUI.php	2007-02-13 10:49:25 UTC (rev 1120)
@@ -81,7 +81,7 @@
 	}
 
 	//gui_element
-	$sql_gel = "SELECT * from gui_element WHERE fkey_gui_id = $1 ";
+	$sql_gel = "SELECT * from gui_element WHERE fkey_gui_id = $1 ORDER BY e_id";
 	$v = array($guiList);
 	$t = array('s');
 	$res_gel = db_prep_query($sql_gel,$v,$t);
@@ -118,7 +118,7 @@
 	}
 	
 	
-	$sql_gelvars = "SELECT * from gui_element_vars WHERE fkey_gui_id = $1 ";
+	$sql_gelvars = "SELECT * from gui_element_vars WHERE fkey_gui_id = $1 ORDER BY fkey_e_id, var_name";
 	$v = array($guiList);
 	$t = array('s');
 	$res_gelvars = db_prep_query($sql_gelvars,$v,$t);