It's supposed to show the moderators and their uploaded photo. Instead, it's showing only 1 moderator. There's no limit on the query... any help is greatly appreciated.
CODE
$DB->simple_construct( array( 'select' => '*', 'from' => 'moderators', 'where' => 'forum_id = '.$this->forum['id'] ) );
$DB->simple_exec();
if ( $DB->get_num_rows() > 0 )
{
$this->output .= "<div class=\"borderwrap\">
<div class=\"maintitle\">
<p><img src='../boards/style_images/h3d/nav_m.gif' border='0' alt='>' width='8' height='8' /> Forum Leaders</p>
</div>
<table cellspacing=\"0\">
<tr>
<td class=\"row1\" valign=\"middle\">
<div style=\"text-align: center;\" align=\"center\">";
}
while( $r = $DB->fetch_row() )
{
$DB->simple_construct( array( 'select' => '*', 'from' => 'member_extra', 'where' => 'id = '.$r['member_id'] ) );
$DB->simple_exec();
while( $r2 = $DB->fetch_row() )
{
$DB->simple_construct( array( 'select' => '*', 'from' => 'members', 'where' => 'id = '.$r['member_id'] ) );
$DB->simple_exec();
while( $r3 = $DB->fetch_row() )
{
$this->output .= "<div align=\"center\" style=\"float: left; padding: 3px;\">
<a href=\"http://dev.highend3d.com/boards/index.php?showuser={$r['member_id']}\"><img src=\"http://dev.highend3d.com/boards/uploads/{$r2['photo_location']}\" alt=\"\" /><br />{$r3['name']}</a>
</div>";
}
}
}
if ( $DB->get_num_rows() > 0 )
{
$this->output .= "</div>
</td>
</tr>
<tr>
<td class=\"catend\" colspan=\"8\"><!-- no content --></td>
</tr>
</table>
</div>";
}
$DB->simple_exec();
if ( $DB->get_num_rows() > 0 )
{
$this->output .= "<div class=\"borderwrap\">
<div class=\"maintitle\">
<p><img src='../boards/style_images/h3d/nav_m.gif' border='0' alt='>' width='8' height='8' /> Forum Leaders</p>
</div>
<table cellspacing=\"0\">
<tr>
<td class=\"row1\" valign=\"middle\">
<div style=\"text-align: center;\" align=\"center\">";
}
while( $r = $DB->fetch_row() )
{
$DB->simple_construct( array( 'select' => '*', 'from' => 'member_extra', 'where' => 'id = '.$r['member_id'] ) );
$DB->simple_exec();
while( $r2 = $DB->fetch_row() )
{
$DB->simple_construct( array( 'select' => '*', 'from' => 'members', 'where' => 'id = '.$r['member_id'] ) );
$DB->simple_exec();
while( $r3 = $DB->fetch_row() )
{
$this->output .= "<div align=\"center\" style=\"float: left; padding: 3px;\">
<a href=\"http://dev.highend3d.com/boards/index.php?showuser={$r['member_id']}\"><img src=\"http://dev.highend3d.com/boards/uploads/{$r2['photo_location']}\" alt=\"\" /><br />{$r3['name']}</a>
</div>";
}
}
}
if ( $DB->get_num_rows() > 0 )
{
$this->output .= "</div>
</td>
</tr>
<tr>
<td class=\"catend\" colspan=\"8\"><!-- no content --></td>
</tr>
</table>
</div>";
}