Is this update syntax correct?

[coder9]

hello

 

the codes

$tmp_name = 'user_box' . $link;


$query = "UPDATE jtablegrid SET '$tmp_name'='$username' WHERE game_no = 1; 
mysql_query($query) or die(mysql_error());

 

thank you.

 

 

[kenrbnsn]

No, the syntax is not correct. Field names should not be quoted with single quotes. Did you try it?

 

<?php
$tmp_name = 'user_box' . $link;
$query = "UPDATE jtablegrid SET $tmp_name = '$username' WHERE game_no = 1; 
mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
?>

 

Ken

[coder9]

No, the syntax is not correct. Field names should not be quoted with single quotes. Did you try it?

 

<?php
$tmp_name = 'user_box' . $link;
$query = "UPDATE jtablegrid SET $tmp_name = '$username' WHERE game_no = 1; 
mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
?>

 

Ken

 

thank you KEN