mysql add column

[ayushchd]

$date = date("F j, Y");
$new = "ALTER TABLE closing ADD May 9, 2007 VARCHAR(30) NOT NULL;";

Is this wrong? mysql says :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9, 2007 VARCHAR(30) NOT NULL' at line 1

Whts The prob?

[ayushchd]

Sorry my mysql query is :

$new = "ALTER TABLE closing ADD $date VARCHAR(30) NOT NULL;";

[henry0]

What is wrong?
I tried it with:
<<<<
ALTER TABLE articles ADD aaaa VARCHAR(30) NOT NULL;
>>>>
which worked fine!
So your problem might be the var values
did you try echoing each of those two?