Updating a unique field in database (example: account username or email)

[eluser]aidehua[/eluser]
Assuming you have an ID column in your table, and you know your user's ID, maybe you could do something like this:

SELECT COUNT(*) dupe FROM $table WHERE $column = '$str' AND id != $id;