[thelist] [mysql] concat problem

[kris burford]

hiya

i'm trying to update a row and add form results to the end of text field.

i've been using:

UPDATE mytable SET mycell = CONCAT(mycell, $FormResults) WHERE id=1

which works fine, on the provision that mycell != null

if mycell is null, then it doesn't work (returns 0 affected rows)

anyone know how i can change this to work?

tia

kris