Whats wrong?

[The_KiD]

Is anyone awake who can tell me what is wrong here:

mysql_query("ALTER TABLE h2h_gamesplayed ADD ' . $game_id . ' VARCHAR( 20 ) NULL");

I know $game_id has a value so that shouldnt be a problem.

 

[Jaffa_Cake]

Is anyone awake who can tell me what is wrong here:

mysql_query("ALTER TABLE h2h_gamesplayed ADD ' . $game_id . ' VARCHAR( 20 ) NULL");

I know $game_id has a value so that shouldnt be a problem.

try

mysql_query("ALTER TABLE h2h_gamesplayed ADD `' . $game_id . '` VARCHAR( 20 ) NULL");

 

[The_KiD]

Thanks Jaffa, although i just got it after I posted. Thanks for help though


Here's how it worked:

mysql_query("ALTER TABLE h2h_gamesplayed ADD `$game_id` VARCHAR(20)");

Any idea how i give it a default value though?

I tried:

mysql_query("ALTER TABLE h2h_gamesplayed ADD `$game_id` VARCHAR(20) SET DEFAULT(0) ");

and

mysql_query("ALTER TABLE h2h_gamesplayed ADD `$game_id` VARCHAR(20) SET DEFAULT `0` ");

neither of which worked :/