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.

Thank you.

Dislexics have more fnu