[ikey07]

format(szLargeString, sizeof(szLargeString), "UPDATE `playeraccounts` SET `forumname` = '%s' WHERE `playername` = '%s'", szPlayerName,name);

Use UPDATE function.
Also see where I set bold, NEVER forget to use mysql_real_escape_string made string in the queries.