update query and "and"

hi,

i'm having a problem with and update query using mysql... the query is:

"update db1 set name='$name' && email='$email' && address='$address' where ID='$ID'";

when i take out the "and" and ask mysql to update only one column, it works fine though ;(

Does anyone know why this is, and if there's a way around it ? Of course i could always make up 3 different queries but i was going to try to make it a bit cleaner ;P

thanks for any help,

nick

Use a comma

> update db1
> SET name='$name',
> email='$email',
> address='$address'
> where id = '$id';