Hi everyone...

I'm new to MySQL and new to this list.....

I've just installed mysql-max-3.23.49 on 2000, which went very well :) I had a few problems hooking Perl into it, but I've now got that resolved too...wohoo...anyway, I'm having problems with UPDATE...when I execute:

UPDATE contacts SET name = "$name" WHERE name = "$name" AND phone = "$phone"
AND mobile = "$mobile";

it works fine. But I can't update more than one value at a time. I want to
update all three columns (name, phone and mobile) at once. How do I do this?

Thanks in advance,

Ewen