This has been asked alot in the codegrrl forums so I thought I would post it on the internet because I get real lazy when it comes to explaining it in the forums. This is only for Enth3 and the file we are going to edit is show_joined.php so please back up the file before reading further. This will work if you have your joined page as a bullet not as a drop down menu.

1. Look for a line in show_joined.php that looks like:
   // show bulletted list instead echo '<p>'; echo 'Select the fanlisting category you want to see below. The list ' . 'only shows categories with fanlistings listed under them.'; echo '</p>';
   And replace it with:
   // show bulletted list instead //ADDED $query2="SELECT * FROM joined"; $result2=mysql_query($query2); $num=mysql_numrows($result2); $query3="SELECT * FROM joined WHERE pending=1"; $result3=mysql_query($query3); $num3=mysql_numrows($result3); //END echo '<p>'; echo 'Select the fanlisting category you want to see below. The list ' . 'only shows categories with fanlistings listed under them.'; echo '</p>';
2. Then a few lines down you will see a line that looks like: echo '<li> <a href="' . $page . $connector . 'cat=all' . '">All ' . 'categories</a></li>'; echo '<li> <a href="' . $page . $connector . 'cat=pending' . '">Pending ' . 'approval</a></li>';
   Replace it with:
   echo '<li> <a href="' . $page . $connector . 'cat=all' . '">All ' . 'categories</a> (' . $num . ') </li>'; echo '<li> <a href="' . $page . $connector . 'cat=pending' . '">Pending ' . 'approval</a> (' . $num3 . ') </li>';
3. Again, a few lines down is this line:
   foreach( $cats as $cat ) echo '<li> <a href="' . $page . $connector . 'cat=' . $cat['catid'] . '">' . $cat['catname'] . '</a>' . $number. '</li>'; } // echo '<li> <a href="' . $page . $connector . 'cat=' . $cat['catid'] . // '"> $catname </a> </li>'; echo '</ul>'; }
   Replace that with:
   //ADDED $result=mysql_query ("SELECT catname, catid FROM category ORDER BY catname ASC"); while ($row=mysql_fetch_array($result)) { $id=$row["catid"]; $queryl="SELECT joinedid FROM joined WHERE catid=$id"; $resultl=mysql_query($queryl); $num_catlink=mysql_numrows($resultl); if ($num_catlink != 0){ echo '<li> <a href="' . $page . $connector . 'cat=' . $row['catid'] . '">' . $row["catname"] . '</a>(' . $num_catlink. ')</li>'; } } } //END
4. That is it. If there are any problems please use the contact information in here.

Loaded in 7.3E-5 seconds.