[SOLVED] Syntax problem

[bluebyyou]

I am trying to create this table, but no mater what I try I keep getting syntax errors. Even when I hard code a year instead of $year I get it. I have tried changing all of my single quotes to these things ` `. I am stumped why It wont work. Can anyone see what I am doing wrong?

 

$query2 = "CREATE TABLE '$year' (
	`day` INT(11) NOT NULL AUTO_INCREMENT,
	`event`' DATE NOT NULL,
	PRIMARY KEY(day))"; 

[bluebyyou]

I forgot to post my mysql version is 4.1.22.

[AndyB]

Try this:

 

$query2 = "CREATE TABLE ". $year. " (
	day INT(11) NOT NULL AUTO_INCREMENT,
	event DATE NOT NULL,
	PRIMARY KEY(day))"; 

[bluebyyou]

Thanks, that worked.