|
From: <ma...@us...> - 2012-01-15 20:46:53
|
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.
|