[SOLVED] Syntax error in updating script...

[Alecdude]

Ok, I'm a bit lost. The code:

if ($_POST['Submit']=='Update')
{
  $profile = $_POST['Desc'];
  
  mysql_query("UPDATE users SET Desc='".$Desc."' WHERE id=".$_SESSION['user_id']."") or die(mysql_error());
  header("Location: myaccount.php?msg=Profile Description Updated!");				
}

 

And it generates this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Desc='Testing, 123 testing...' WHERE id=47' at line 1

 

Help?

[premiso]

Desc is a reserved word. Encapsulate it in backticks(`) or better yet change that column name.

 

if ($_POST['Submit']=='Update')
{
  $profile = $_POST['Desc'];
  
  mysql_query("UPDATE users SET `Desc`='".$Desc."' WHERE id=".$_SESSION['user_id']."") or die(mysql_error());
  header("Location: myaccount.php?msg=Profile Description Updated!");


}