Tadashi Okoshi
slash****@users*****
2005年 12月 19日 (月) 17:38:53 JST
Index: affelio/lib/Affelio/Managing/MyNewsManager.pm
diff -u affelio/lib/Affelio/Managing/MyNewsManager.pm:1.4 affelio/lib/Affelio/Managing/MyNewsManager.pm:1.5
--- affelio/lib/Affelio/Managing/MyNewsManager.pm:1.4 Mon Dec 19 15:13:01 2005
+++ affelio/lib/Affelio/Managing/MyNewsManager.pm Mon Dec 19 17:38:53 2005
@@ -14,7 +14,7 @@
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
#
-# $Id: MyNewsManager.pm,v 1.4 2005/12/19 06:13:01 slash5234 Exp $
+# $Id: MyNewsManager.pm,v 1.5 2005/12/19 08:38:53 slash5234 Exp $
package Affelio::Managing::MyNewsManager;
{
@@ -68,7 +68,7 @@
$app_list ="app_install_name='" . $app_list . "'";
debug_print("MyNews::retrieve: apps [$app_list]");
- my $query= "SELECT nid, datetime, app_install_name, title, description, creator, URL FROM AFuser_CORE_my_news WHERE datetime > $laterthan and ($app_list)";
+ my $query= "SELECT nid, datetime, app_install_name, title, description, creator, URL FROM AFuser_CORE_my_news WHERE datetime > $laterthan and ($app_list) order by datetime desc";
debug_print("MyNews::retrieve: query [$query]");
##############################