problem driving me mad

[Admin]

You can join the user and userfield tables right in the first query:

$users = $DB_site->query("
	SELECT userid,username,usertitle,field14
	FROM user
	WHERE username LIKE '%".addslashes(htmlspecialchars($findname))."%'
	ORDER BY username
");

echo "<table>";
if ($DB_site->num_rows($users)>0) {
	echo "<tr><td nowrap><p><b>Team Members Found:</b></p></td>".iif($perms[ismoderator] or $bbuserinfo['usergroupid']==25, "<td nowrap><p>&nbsp;</p></td>", "").iif($perms[ismoderator] or $bbuserinfo['usergroupid']==25, "<td nowrap><p>&nbsp;</p></td>", "")."</tr>\n";
	while ($user=$DB_site->fetch_array($users)) {
		echo "<tr><td nowrap><p>$user[username] - $field[field14]</p></td>".iif($perms[ismoderator] or $bbuserinfo['usergroupid']==25, "<td nowrap><a href=\"user.php?action=viewuser&userid=$user[userid]\"><p>[view user]</a> <a href=\"user.php?action=edituser&userid=$user[userid]\">[Edit User]</a></p></td>", "")."</tr>\n";
	}
}
echo "</table>";

You also have this code twice in there, not sure it's supposed to be there (and if it is, use only one iif()):

iif($perms[ismoderator] or $bbuserinfo['usergroupid']==25, "<td nowrap><p>&nbsp;</p></td>", "")