Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv11699
Modified Files:
serendipity_functions.inc.php
Log Message:
Add URL as secondary ORDER BY criteria.
Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- serendipity_functions.inc.php 1 Apr 2003 09:37:21 -0000 1.14
+++ serendipity_functions.inc.php 1 Apr 2003 19:12:13 -0000 1.15
@@ -1443,11 +1443,11 @@
function serendipity_displayTopUrlList($list, $limit) {
global $serendipity;
- $query = "SELECT url, sum(count) AS total
+ $query = "SELECT url, SUM(count) AS total
FROM $serendipity[dbPrefix]$list
WHERE weblogid='$serendipity[weblogId]'
GROUP BY url
- ORDER BY total desc
+ ORDER BY total DESC, url
LIMIT $limit";
$rows = serendipity_db_query($query);
|