diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-03-02 01:26:55 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-03-02 01:26:55 +0000 |
| commit | 4b809856ace755fadc639b2df6b6d52637cf10e1 (patch) | |
| tree | a5e1f1e48439e7db65ca8d4e34233589e4d8e78b /phpBB/index.php | |
| parent | bed1036f6c16af6850bc1c09aa4df53ce173d02c (diff) | |
| download | forums-4b809856ace755fadc639b2df6b6d52637cf10e1.tar forums-4b809856ace755fadc639b2df6b6d52637cf10e1.tar.gz forums-4b809856ace755fadc639b2df6b6d52637cf10e1.tar.bz2 forums-4b809856ace755fadc639b2df6b6d52637cf10e1.tar.xz forums-4b809856ace755fadc639b2df6b6d52637cf10e1.zip | |
Preliminary MSSQL compability updates
git-svn-id: file:///svn/phpbb/trunk@70 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/index.php')
| -rw-r--r-- | phpBB/index.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/index.php b/phpBB/index.php index f50f727f0d..8cfffd9c3f 100644 --- a/phpBB/index.php +++ b/phpBB/index.php @@ -46,7 +46,7 @@ $template->set_block("catrow", "forumrow", "forums"); $sql = "SELECT c.* FROM ".CATEGORIES_TABLE." c, ".FORUMS_TABLE." f WHERE f.cat_id=c.cat_id - GROUP BY c.cat_id + GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order"; if(!$q_categories = $db->sql_query($sql)) { @@ -106,6 +106,7 @@ if($total_categories) $created_line = false; for($j = 0; $j < $total_forums; $j++) { + if( ( $forum_rows[$j]["cat_id"] == $category_rows[$i]["cat_id"] && $viewcat == -1 ) || ( $category_rows[$i]["cat_id"] == $viewcat) ) { |