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 is to show the latest 5 joined fanlistings.

1. Look for a line in show_joined.php that looks like:
   <form method="get" action=""> <p class="center">
   And underneath that line add:
   <*//added $query2 = "SELECT * FROM joined ORDER BY added DESC LIMIT 5"; $result2 = mysql_query( $query2 ); while ($row2 = mysql_fetch_array($result2)){ echo "<a href=". $row2['url'] . " target=\"_blank\">"; echo "<img src=URL TO JOINED IMAGE FOLDER" .$row2['imagefile'] . " alt=\"". $row2['subject'] . "\" border=0 /></a> "; }//end *><p>
   If you look at the first line, you will see the number 5. If you want to show the latest 3 fanlistings, change that to 3 or to whatever number you wish. Also you have to replace * with ?.
2. Then a few lines down you will see a line that looks like:
   else if( ( isset( $show_list ) && $show_list ) && ( !isset( $_GET['cat'] ) || $_GET['cat'] == '' ) ) { // show bulletted list instead
   Underneath that line add the exact same piece of coding that I posted in the previous step (the one with the $query2).
3. That is it. If there are any problems please use the contact information in here.

Loaded in 7.3E-5 seconds.