$c_name = sprintf('SELECT userid FROM users WHERE UPPER(username) = UPPER("%s") AND userid != %d', $db->escape($_POST['newname']), $ir['userid']);
$c_name = $db->query($c_name);
if ($db->num_rows($c_name) > 0) {
echo "Username already taken.
\n";
}
$c_login = sprintf('SELECT userid FROM users WHERE UPPER(login_name) = UPPER("%s") AND userid != %d', $db->escape($_POST['new_loginname']), $ir['userid']);
$c_login = $db->query($c_login);
if ($db->num_rows($c_login) > 0) {
echo "Login name already taken.
\n";
}
There... you can do the rest of it :)