View Single Post
  #4  
Old 06-04-2008, 09:14 PM
warmonger Offline
forum loafer
 
Join Date: May 2008
Posts: 6
I noticed the same thing was happening when I switched over the the paged_archive addon. The same change (in my original post above) can be applied to line 570 in the paged_archive.php page.

Change:
Code:
$query = mysql_query("SELECT * FROM ".$pixelpost_db_prefix."categories ORDER BY name");
to this:
Code:
$query = mysql_query("SELECT DISTINCT C1.id, C1.name, C1.alt_name FROM " .$pixelpost_db_prefix. "categories C1 INNER JOIN " .$pixelpost_db_prefix. "catassoc C2 ON C2.cat_id = C1.id ORDER BY C1.name");
Reply With Quote