How to Append data

Author Name Status Posted Time Henri Teipel 2/13/2007 10:41:30 PM Author is Offline 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. Thanks Reguards Henri

Subject Author Status Date How to Append data Helena Eugine Gonsalves 2/13/2007 10:49:33 PM Perhaps you should look into using the UPDATE SQL command.. I think that it is what you are loo king for. Post Comments Re: How to Append data Andrez Sudol 2/13/2007 10:54:54 PM 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 Andrez Post Comments Re: How to Append data Henri Teipel 2/13/2007 10:57:35 PM Hello Andrez, Thanks for the UPDATE command I think so this will definetely do my work but wha t is the syntax to add old data and new data in one table. Thanks Reguards Nikhil Henry Teipel Post Comments

Related Forums Optimizing Images Get a Website Template for Free!!! Get a Website Template for Free!!! Reply to Hesus!!! Do You Sell Your Templates on Ebay?