[GNUnet-SVN] r4896 - GNUnet/src/applications/sqstore_mysql

[gnunet]

Author: grothoff
Date: 2007-06-02 00:55:00 -0600 (Sat, 02 Jun 2007)
New Revision: 4896

Modified:
   GNUnet/src/applications/sqstore_mysql/mysql.c
Log:
order here too

Modified: GNUnet/src/applications/sqstore_mysql/mysql.c
===================================================================
--- GNUnet/src/applications/sqstore_mysql/mysql.c       2007-06-02 06:51:48 UTC 
(rev 4895)
+++ GNUnet/src/applications/sqstore_mysql/mysql.c       2007-06-02 06:55:00 UTC 
(rev 4896)
@@ -205,7 +205,7 @@
 
 #define INSERT_SAMPLE "INSERT INTO gn070 
(size,type,prio,anonLevel,expire,hash,value) VALUES (?,?,?,?,?,?,?)"
 
-#define SELECT_SAMPLE "SELECT * FROM gn070 WHERE hash=?"
+#define SELECT_SAMPLE "SELECT * FROM gn070 WHERE hash=? ORDER BY expire DESC"
 
 #define SELECT_SAMPLE_COUNT "SELECT count(*) FROM gn070 WHERE hash=?"