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
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.