You can join the user and userfield tables right in the first query:
Code:
$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> </p></td>", "").iif($perms[ismoderator] or $bbuserinfo['usergroupid']==25, "<td nowrap><p> </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()):
Code:
iif($perms[ismoderator] or $bbuserinfo['usergroupid']==25, "<td nowrap><p> </p></td>", "")