Cannot create tables

[philgh]

Help!
I get errors when i run this to try creating a table.
Please anyone help me correct if there is an error

CREATE TABLE `comments_visitors` (
`id_comm` int(11) NOT NULL auto_increment,
`idart_comm` int(11),
`text_comm` varchar NOT NULL default '',
'idusr_comm' int(11) NOT NULL DEFAULT '',
`date_comm` date NOT NULL default '0000-00-00',
`valid_comm` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id_comm`)
);


Please help

[fenway]

A number of problems:

- you're using string literals instead of backticks for the "idusr_comm" column (not that backticks are necessary at all)
- you need to specify a length for the varchar column type for the "text_comm" column
- your default for INT should really be 0, not '', for "idusr_comm"

Hope that helps.

[paul2463]

Hi here is the code that will create the table for you:

[code]
CREATE TABLE `comments_visitors` (
  `id_comm` int(11) unsigned NOT NULL auto_increment,
  `idart_comm` int(11) unsigned NOT NULL default '0',
  `text_comm` varchar(255) NOT NULL default '',
  `idusr_comm` int(11) unsigned NOT NULL default '0',
  `date_comm` date NOT NULL default '0000-00-00',
  `valid_comm` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_comm`)
)[/code]

hope that helps as well