[Openautomation-svn] SF.net SVN: openautomation:[657] tools/rsslog/rsslog.php

[<ma...@us...>]

Revision: 657
          http://openautomation.svn.sourceforge.net/openautomation/?rev=657&view=rev
Author:   makki1
Date:     2012-01-15 20:46:47 +0000 (Sun, 15 Jan 2012)
Log Message:
-----------
rsslog: missing commit of sort-order

Modified Paths:
--------------
    tools/rsslog/rsslog.php

Modified: tools/rsslog/rsslog.php
===================================================================
--- tools/rsslog/rsslog.php	2012-01-15 20:13:17 UTC (rev 656)
+++ tools/rsslog/rsslog.php	2012-01-15 20:46:47 UTC (rev 657)
@@ -196,7 +196,8 @@
 {
 //  $q = "SELECT content, strftime('%s', t, 'localtime') AS t FROM Logs";
   $q = "SELECT title, content, tags, strftime('%s', t) AS t FROM Logs " .
-       "WHERE tags LIKE '%" . sqlite_escape_string($filter) . "%'";
+       "WHERE tags LIKE '%" . sqlite_escape_string($filter) . "%' " .
+       "ORDER by t DESC";
   return sqlite_query( $db, $q, SQLITE_ASSOC );
 }
 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.