Update SQL

[alirezaok]

Why this SQL show "no sucsessfull update" always ? 🙁

include("config.php");
$Link = mysql_connect ($Host, $User, $Password);
$Query = 'UPDATE $TableName SET `title` = \'test\','
. ' `lid` = \'test\','
. ' `body` = \'test\' WHERE `id` = \'$id\';'
. ' ';
if (mysql_db_query ($DBName, $Query, $Link)) {
print ("<div align=center>successfulle update</div>\n");
} else {
print ("no sucsessfull update");
} 

i sure that connect to mysql and table is true because row delete works but update not works ...

[LordShryku]

Small pet peeve: You need to indent. Try this:

$Query = "UPDATE ".$TableName."
          SET    title = 'test',
                 lid = 'test',
                 body = 'test'
          WHERE  id = '".$id."'";

[tekky]

$DBName not set either.... which could be the problem (or you could have not pasted that line of code...)