Code:


  $num_rows = 5; // members to show

  $sql = "SELECT * FROM {$dbpref}users ORDER BY user_id DESC LIMIT 0, $num_rows";
  $result = mysql_query($sql) or die(mysql_error(). "e98438760jnds09");

?>

<br><table class=topictable cellspacing=0>
<tr>
<td class=topictitle width=50% style="text-align:left; padding-left: 10px;">New Users</td>
<td class=topictitle width=25%>Registered</td>
<td class=topictitle width=25%>Posts</td>
</tr>

<?

while($row = mysql_fetch_array($result))
{
   $member_regdate = format_datetime($row['user_regdate'], $user_timezone);
   print "<tr class=topicrow0 align=center><td class=topiccell align=left><a class=linkbutton href='".$forumscript."?a=member&m=".$row['user_id']."'>".$row['user_name']."</a></td><td class=topiccell align=center >". $member_regdate ."</td><td class=topiccell align=center >".  $row['user_numposts'] ."</td></tr>";
}

?>
</table>
<?