using UPDATE

[OwenTheSamoan]

I'm using php with mysql. I have a field in my table named "member" which has the names of the members of my site. I want to change the value in this field by adding a prefix to some of the member's names. Let's suppose there is a member named "Joe" in the "member" field. I want to change the value of this field to "JoeNEW". I'm guessing I would do something like this---
Update table_name set member ="$member"."NEW" where member="$member";

this doesn't work. Where am I going wrong?

[thorpe]

mysql_query("UPDATE tbl SET member='$member"."NEW' WHERE member='$member'");

[OwenTheSamoan]

I just tried doing it like this and it worked. Thanks.

update table set member ='$member new' where member='$member';

[thorpe]

sure... if you want spaces between joe and NEW.

up to you :-P