[Devel] r198 - trunk

[svn AT agendadulibre.org]

Author: thomas
Date: Thu Jan  4 14:41:47 2007
New Revision: 198

Modified:
   trunk/funcs.inc.php

Log:
- Dans le calendrier, pour chaque jour, les évènements sont maintenant
  triés par l'ordre alphabétique de la ville. Merci à Erwan
  <air1 AT imaginair.net> pour cette contribution.



Modified: trunk/funcs.inc.php
==============================================================================
--- trunk/funcs.inc.php (original)
+++ trunk/funcs.inc.php Thu Jan  4 14:41:47 2007
@@ -214,13 +214,15 @@
     $sql = "select * from events where
                       ((end_time >= " . 
$db->quote_smart(date_timestamp2mysql($cur)) . ") AND
                       (start_time <= " . 
$db->quote_smart(date_timestamp2mysql($next)) . ") AND
-                      (moderated = 1))";
+                      (moderated = 1))
+                      order by city";
   else
     $sql = "select * from events where
                       ((end_time >= " . 
$db->quote_smart(date_timestamp2mysql($cur)) . ") AND
                       (start_time <= " . 
$db->quote_smart(date_timestamp2mysql($next)) . ") AND
                       (moderated = 1) AND
-                      (region = " . $db->quote_smart($region) . "))";
+                      (region = " . $db->quote_smart($region) . "))
+                      order by city";
 
   $result = $db->query ($sql);