member changing there own username

[brand]

hi there ppl i am trying to sort out so members can change there own username i am using wapdesire v_2

i have put this lot in settings/profile.php

$name=mysql_fetch_array(mysql_query("SELECT username FROM users WHERE id='".getuid_sid($sid)."'"));

Username: <input name=\"name\" maxlength=\"100\" value=\"$name[0]\"/><br/>

username='".$name."'

and when i go to change me profile it says error updating profile and some one help me and tell me here i am going wrong please

also can some one tell me how i get it to go in the logs as well when some one changes there name thanks to any one that can help me out this this

[ksg91]

you provided very insufficient detail about what you saying. none of the code you posted above relates to updating username.

[neostar]

Write here the sql code 4 updating username.