[SOLVED] did i do UPDATE for mysql correctly?

[MDanz]

did i do this correctly?

$id = mysql_real_escape_string($_POST['id']);
$name = mysql_real_escape_string($_POST['name']);
$username1 = mysql_real_escape_string($_POST['username']);
$imagelocation = mysql_real_escape_string($_POST['imagelocation']);

      // into our database.

      $query = "UPDATE castack SET";
      $query .= "(`name`, `name`, `username`, `imagelocation`) VALUES ('$name', '$username1', '$imagelocation') WHERE id=$id";
  
      $results = mysql_query($query, $link);

 

 

its not updating.. where did i go wrong?

[rhodesa]

whenever you are debugging mysql_query() you should do it in the form of:

      $results = mysql_query($query, $link) or die(mysql_erryr($link));

it will provide useful info on what you are doing wrong.

 

on that note, UPDATEs are not the same as INSERTs:

http://dev.mysql.com/doc/refman/5.1/en/update.html

      $query = "UPDATE castack SET ";
      $query .= "`name` = '$name', `username` = '$username1', `imagelocation` = '$imagelocation' WHERE id=$id";