How to Append data

Hi Friends, I need to be able to add some new data to some old data in my DB. No matter what
the old data is I need to add some new data to it. So if there are two rows with the words “RE
D” in one and “Black” in the other, if I append a “1″ to the rows they should look like “RED1″
and “Black1″. I was thinking of a statement format such as: PHP Code: $sql = “append
table set A = ‘(old data)+(new data)’ where B = ‘B’”;
$sth = mysql_query($sql);
I can’t
get it to work. Can this be done or is there a different command I need? Thanks in advace for
your help.

Read more about it at buzzycode.com