MySQL Update question

[Anon]

Hi! This is a dumbly simple question, but I've never had to deal with it and can't any examples on how to do it.

I need to update a MySQL field with 2 variables:

"UPDATE Directory SET email_sent = $lstgs['email_sent'], $appear_in" ......

But that won't work, so I need someway to get the same info in there. What it is doing is appending the current value with the current value + a new value, ie. "List1,List2" --> "List1,List2,List3".

Any ideas?

Thanks in advance!

[spider_man]

Pre-concatenate it;

"UPDATE Directory SET email_sent = '" . $lstgs['email_sent'] . $appear_in . "'";

I've added a quote there, i bet my salary, that's not a numeric datatype.
(kidding about the bet, I won't give away my salary ;P )