Creating database and tables. chapter 9
I have a problem with the code from the book, it won't let me use the following :-
$user_table_def = "usernumber MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,";
if I take away the DEFAULT '0', then it works but i have a problem running the userviewer.php script... it says:-
Error:1054: unknown column 'usernumber in field list'.
I tried to enter that line using command line client and it still wouldn't work. Somewhere there is a problem, you can't seem to use DEFAULT and NOT NULL AUTO_INCREMENT together.
Can anyone tell me how to fix this.
Dislexics have more fnu