Update query not working

[pug]

I am trying to update a table. I know this script is getting the values for the variables because I'm printing them out to the screen. What is wrong with my query?

$query = "UPDATE people
set name = '$name', set address = '$address', 
 set phone = '$phone', set cell = '$cell', set email = '$email', set website = '$website'
WHERE name = '$name'";

$result = mysql_query($query);
if(!$result)
echo "Error editing contact";

[swon]

Don't make for every field a new set, only one time at the beginning:
<?

$query = "UPDATE people
set name = '$name', address = '$address', phone = '$phone', cell = '$cell',email = '$email', website = '$website'
WHERE name = '$name'";

$result = mysql_query($query);
if(!$result)
echo "Error editing contact";
?>

[pug]

Thanks! That really helped a lot

One last problem.

It updates everything except for the name. I echoed the name so I know it is getting a value but it doesn't change it but it changes everything else

[swon]

that's because the statement --WHERE name='$name'-- takes the tablefield named 'name' for the key and can't update that, may you should use an 'id' field in your table and in the query you say --WHERE id='$id'--

[pug]

Doh!

Thanks