PHP Update

[Exoon]

Hello,

 

I can't seem to figure this simple thing out, ive not done php in a while so might be missing somthing simple out but i just can't see it.

 

$title = $_POST['title'];
$post = $_POST['post'];
$post = nl2br($post);
$by = $_POST['by'];
$id = $_POST['id'];
echo $id;
$sql = "UPDATE `blog_dl` SET `title` = \'$title\', `body` = \'$post\', `poster` = \'$by\' WHERE `id` = $id LIMIT 1;";
if(mysql_query($sql) or die(mysql_error())){
  echo "updated";
  }

 

 

It gives 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 '\'1234\', `body` = \'123\', `poster` = \'123\' WHERE `id` = 12 LIMIT 1' at line 1

 

Thanks in advance

[TOA]

It gives 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 '\'1234\', `body` = \'123\', `poster` = \'123\' WHERE `id` = 12 LIMIT 1' at line 1

 

Thanks in advance

 

Try taking out the escapes and see what that does

[KevinM1]

Try:

 

$sql = "UPDATE blog_dl SET title = '$title', body = '$post', poster = '$by' WHERE id = $id LIMIT 1;"