Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ThankYou2
-
Rename a Username
The WHERE Username=$1d2 is the $id2 but i just did this and it works, maybe not the right way but it worked $sql="UPDATE NatHotLap set Username='$id ' where Username='$id2'"; $result=mysql_query($sql); $sql1="UPDATE NatTRT set Username='$id ' where Username='$id2'"... -
Rename a Username
Hi sorry for asking again but i seem to of mis under stood mutible tables i made a form with two drop down menus an they both echo selected names to page, an in address bar,then it calls a new page that updates names. this works great below $sql="UPDATE NatHotLap set Username='$id ' where... -
Rename a Username
thanks for your time an replys, im going to put this query in a form so i can do all the tables at one time. have a nice thanks giving :) -
Rename a Username
1 more question if you dont mind can i use this on several tables UPDATE mytable and mytable and mytable and mytable and mytableSET set Username='Roy2' where Username='Roy1' -
-
Rename a Username
thanks for your reply, im trying to change a name in the database username from roy1 to roy2 and i tryed what you sudjested but still get error, i did do this once a few years back but im getting old an cant remmber how i did it. UPDATE TABLE SET Username = 'roy1' WHERE Username = 'roy1'... -
Rename a Username
im trying to rename a user name in my data base and i used this syntex below in my database sql, but getting error i looked/searched here but didnt seem to see what i want and yes im a newbee please help with full syntex thanks update table set Username=replace(Username,'roy1','roy2') where...
