Error creating table in MySQL 5.0

[Marvin Cummings]

Wondering if anyone can give me some help with this error I'm getting
when trying to create this table:

 

ERROR 1064 (42000): 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 '$sql

 = "CREATE TABLE $subdivtable (

$subdivcolumn[subdiv_title] varchar(50),

$su' at line 1

 

The syntax I'm using to create this table: 

 

...\bin\Mysql> $sql = "CREATE TABLE $subdivtable ( 
            $subdivcolumn[subdiv_title] varchar(50), 
            $subdivcolumn[subdiv_id] int(4) DEFAULT '0' NOT NULL
auto_increment, 
            $subdivcolumn[country_id] int(4) NOT NULL, 
            PRIMARY KEY(subdiv_id))"; 

 

I'm running mysql 5.0 on a w2k3 server.