[dusk]

Hello, how do i add text into a MySQL field?

If I send a normal UPDATE query, text gets deleted, and only the new one is written. Is it possible to add to it?

[Vince]

Probably with the CONCAT() function.

PHP код:

textfield = concat(textfield, 'new text here') 


[DanishHaq]

Nevermind, he was quicker ^^.

[dusk]

Quote:

Originally Posted by Vince Probably with the CONCAT() function. PHP код: textfield = concat(textfield, 'new text here')

But in this case i would have to load the old text first wouldn't i?

[Vince]

No. The old values aren't overwritten until the query is done.