I've almost made it through my webpage without asking questions, but this problem has me stumped.

I am trying to create a new table with the ID column being NOT NULL AUTO_INCREMENT.

The table will create if I do not have NOT NULL AUTO_INCREMENT, but it WILL NOT create if I add those commands.

Here is my code:

mysql_query(
            "CREATE TABLE fb_$user_id 
                (
                 id MEDIUMINT NOT NULL AUTO_INCREMENT,
                 user_id INT(11), 
                 courseid INT(10), 
                 score INT(13), 
                 date TEXT
                )"
            );

Hopefully this code shows up correctly. I did follow the 'how to post code block correctly' instructions.

Thanks for your help