Do i need to put quotes for this variable?

[coder9]

hi

 

i have this codes again,

 

$query = "UPDATE jtablegrid SET $tmp_name='$username' WHERE game_no = $game_no_tempo"; 

 

 

i'm confuse if i need to put quotes of $game_no_tempo,

 

this,

$query = "UPDATE jtablegrid SET $tmp_name='$username' WHERE game_no = $game_no_tempo"; 

 

or

 

this,

$query = "UPDATE jtablegrid SET $tmp_name='$username' WHERE game_no = '$game_no_tempo'"; 

 

with? or without the quotes?

 

 

thank you.

 

[Xurion]

$query = "UPDATE jtablegrid SET $tmp_name='$username' WHERE game_no = '$game_no_tempo'";

 

Unless the game_no column is a number type, then either will work.

[Wolphie]

This is how I would do it:

 

$query = "UPDATE `jtablegrid` SET $tmp_name = '$username' WHERE `game_no` = '$game_no_tempo'";

 

Just out of curiosity, what is $tmp_name? Is it just a variable storing a field name?

[coder9]

This is how I would do it:

 

$query = "UPDATE `jtablegrid` SET $tmp_name = '$username' WHERE `game_no` = '$game_no_tempo'";

 

Just out of curiosity, what is $tmp_name? Is it just a variable storing a field name?

 

@Wolphie yes it's just a temporary variable.

 

and by the way the $game_no_tempo is an integer. is your query correct for this?

 

thank you .

[Xurion]

You don't need to put quotes around a number type. For clarity, I always code the correct way.