[SOLVED] SQL Syntax - Can't Find The Error

[refiking]

Here's the Error Message:

 

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 '= Home WHERE sid = '15'' at line 1

 

$update2 = mysql_query("UPDATE history SET" .$ptid. "= '$title' WHERE sid = '$sid'")or die(mysql_error());

 

I checked each variable and they all passed with no problem and here is the other query that passed with no problem.  To me, they are identical in regard to structure.

 

$update = mysql_query("UPDATE history SET " .$pid. "= '$text' WHERE sid = '$sid'")or die(mysql_error());

[Maq]

Try this:

 

$update2 = mysql_query("UPDATE history SET '" . $ptid . "' = '" . $title . "' WHERE sid = '" . $sid ."'")or die(mysql_error());

[refiking]

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 ''p1title' = 'Home' WHERE sid = '15'' at line 1

[jonsjava]

<?php
$update2 = mysql_query("UPDATE `history` SET `$ptid`='$title' WHERE sid = '$sid';")or die(mysql_error());

[refiking]

That worked.  You inadvertently placed an extra semicolon in the string, but once I removed that it worked perfectly.  Thanks!

[nadeemshafi9]

$pid has nothing in it, its meant to be a feild name isnt it looks more like and id, ok cool u sorted it