create new columns from a variable (PHP & MySQL)

Hi,

I am trying to create a new column in a table where the column name will be equal to the value of a variable.

$trendDate = date("F_j_Y");

$newCol = 'ALTER TABLE trendData ADD $trendDate INT(5)';

mysql_query($newCol); 

PHP:

However what's happening is that the new column is just being named $trendDate (not the actual value). Is it possible for me to do what I am trying to do? Thanks in advance!

 

Place the query string between double quotes. Variables won't be parsed between single quotes.