Search results for query: *

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'"...

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...

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 :)

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'

thanks that did it sorry for my newbyest

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'...

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...