cgi mysql error Please help

[club69]

I keep getting a build db error at this line. says check mysql manual for syntex
mysql version 4.0.22 I can't find anything about this syntex error. Please help.

my($query) = "CREATE TABLE DMtgpdead (
deadurl varchar(255) NOT NULL default '',
''idnum varchar(20) NOT NULL default
);";

Thanks Club69

[Whir]

Is it expecting NULL? That's what it seems like.

[club69]

this is a tgp script and I have no clue what it is looking for