Changeset 6420

Timestamp:

Apr 8, 2008, 5:39:31 PM (13 years ago)

Author:

ogawa

Message:

#2059:merged:ソート順が同一だった場合にc_profile_id順にソートする修正

File:

• OpenPNE/branches/work/ogawa/2059_profile/webapp/lib/db/member.php (modified) (1 diff)

OpenPNE/branches/work/ogawa/2059_profile/webapp/lib/db/member.php

@@ -483 +483 @@
 {
     $hint = db_mysql_hint('FORCE INDEX (sort_order)');
-    $sql = 'SELECT * FROM c_profile' . $hint . ' ORDER BY sort_order';
+    $sql = 'SELECT * FROM c_profile' . $hint . ' ORDER BY sort_order,c_profile_id';
     return db_get_all($sql);
 }