Objet : devel-adl
Archives de la liste
- From: thomas AT lolut.utbm.info
- To: devel AT agendadulibre.org
- Subject: [Devel] r120 - trunk
- Date: Thu, 29 Dec 2005 15:03:12 +0100 (CET)
- List-archive: <http://lolut.utbm.info/pipermail/devel>
- List-id: Developpement de l'Agenda du Libre <devel.agendadulibre.org>
Author: thomas
Date: 2005-12-29 15:03:11 +0100 (Thu, 29 Dec 2005)
New Revision: 120
Modified:
trunk/rss.php
Log:
Sort RSS feed items by starting date. Thanks to David Mentre.
Modified: trunk/rss.php
===================================================================
--- trunk/rss.php 2005-12-23 09:49:05 UTC (rev 119)
+++ trunk/rss.php 2005-12-29 14:03:11 UTC (rev 120)
@@ -51,14 +51,16 @@
{
$sql = "select * from events where " .
"(start_time <= '" . date_timestamp2mysql($end) . "') AND " .
- "(end_time >= '" . date_timestamp2mysql($start) . "') AND
(moderated=1)";
+ "(end_time >= '" . date_timestamp2mysql($start) . "') AND
(moderated=1)" .
+ "ORDER BY start_time ASC";
}
else
{
$sql = "select * from events where " .
"(start_time <= '" . date_timestamp2mysql($end) . "') AND " .
"(end_time >= '" . date_timestamp2mysql($start) . "') AND " .
- "((region=" . $region . ") OR (locality=1)) AND (moderated=1)";
+ "((region=" . $region . ") OR (locality=1)) AND (moderated=1)" .
+ "ORDER BY start_time ASC";
}
return $db->query ($sql);
- [Devel] r120 - trunk, thomas, 29/12/2005
Archives gérées par MHonArc 2.6.16.