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

Thanks

Reguards
Nikhil

Perhaps you should look into using the UPDATE SQL command.. I think that it is what you are looking for.

if you want to create a new table with old data and new data it's ok,

if you want to add old data and new data in one table

use UPDATE statement for that

regards
jitender

__________________
Free Webmaster Tools - Free SEO Tools
phpLDHacks - Add your template or Hack and earn money
Text Link Ads - Buy & Sell text link ads

Hello jitender

Thanks for the UPDATE command I think so this will definetely do my work but what is the syntax to add old data and new data in one table.

Thanks

Reguards
Nikhil