diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-02-27 18:52:10 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-02-27 18:52:10 +0000 |
| commit | 760e5a23eb6cca4b78fa4e430c6316131daf5fca (patch) | |
| tree | 45dafe59576993d4b3150d866bd1fc6b500f6a8d /phpBB/index.php | |
| parent | ad9d4d2605a2f1b448876f922d0cc20790c90f39 (diff) | |
| download | forums-760e5a23eb6cca4b78fa4e430c6316131daf5fca.tar forums-760e5a23eb6cca4b78fa4e430c6316131daf5fca.tar.gz forums-760e5a23eb6cca4b78fa4e430c6316131daf5fca.tar.bz2 forums-760e5a23eb6cca4b78fa4e430c6316131daf5fca.tar.xz forums-760e5a23eb6cca4b78fa4e430c6316131daf5fca.zip | |
Add forum ordering to Index
git-svn-id: file:///svn/phpbb/trunk@68 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/index.php')
| -rw-r--r-- | phpBB/index.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/index.php b/phpBB/index.php index b5716bc6b6..f50f727f0d 100644 --- a/phpBB/index.php +++ b/phpBB/index.php @@ -66,11 +66,11 @@ if($total_categories) $limit_forums = " WHERE f.cat_id = $viewcat "; } $sql = "SELECT f.*, u.username, u.user_id, p.post_time - FROM ".FORUMS_TABLE." f + FROM ".FORUMS_TABLE." f LEFT JOIN ".POSTS_TABLE." p ON p.post_id = f.forum_last_post_id LEFT JOIN ".USERS_TABLE." u ON u.user_id = p.poster_id $limit_forums - ORDER BY f.forum_id"; + ORDER BY f.cat_id, f.forums_order"; if(!$q_forums = $db->sql_query($sql)) { error_die($db, QUERY_ERROR); |