[SOLVED] Adding content...

[Germaris]

Hi there!

 

Could somebody explain what is the right PHP syntax for a query which can update a MySQL table field by ADDING a content to it WITHOUT deleting/replacing its existing content?

 

Many thanks in advance for your help!

 

Best regards,

 

Gerry

[Prismatic]

mysql_query("INSERT INTO <yourtable> (column, column2) VALUES ('first value', 'second value')");

 

edit ohh I see update..

 

mysql_query("UPDATE <yourtable> SET column = 'new  value' WHERE id = 2");

 

you get the idea..  I hope :|

[AndyB]

What you need to do is:

 

read the 'old content' value

add the new content to the old content (or v/v) using the concatenation operator - the dot

UPDATE the database table with the concatenated content

 

[Germaris]

What you need to do is:

 

read the 'old content' value

add the new content to the old content (or v/v) using the concatenation operator - the dot

UPDATE the database table with the concatenated content

 

 

 

Thanks for replying to both of you.

And the winner is...  Andy!

 

I did

UPDATE table SET column = CONCAT(column," string") WHERE column2 = "value";

And it worked nice at the very first attempt.

 

 

 

 

 

[Prismatic]

Didn't know it was a competition 

 

 

[Germaris]

Didn't know it was a competition 

 

It was just a joke.

:-)

Didn't want to offend anybody...