Need Help, Big Time. PHP

[skippa]

Whats wrong with this?

 

CREATE TABLE `poker` (

  `id` int(11) NOT NULL auto_increment,

  `player1` varchar(40) NOT NULL default '',

  `player2` varchar(40) default NULL,

  `player3` varchar(40) default NULL,

  `player4` varchar(40) default NULL,

  `cards1` varchar(250) default NULL,

  `cards2` varchar(250) default NULL,

  `cards3` varchar(250) default NULL,

  `cards4` varchar(250) default NULL,

  `money1` int(11) default '0',

  `money2` int(11) default '0',

  `money3` int(11) default '0',

  `money4` int(11) default '0',

  `status` varchar(250) NOT NULL default '',

  `ante` int(16) NOT NULL default '0',

  `pot` int(16) NOT NULL default '0',

  `stage` int(1) default '0',

  `swapstart` int(1) NOT NULL default '0',

  `currentraise` int(1) NOT NULL default '0',

  `allin` binary(1) NOT NULL default '0',

  `lastmove` int(11) default NULL,',

  `created` int(11) NOT NULL default '0',

  `p1` varchar(100) NOT NULL default '',

  `p2` varchar(100) NOT NULL default '',

  `p3` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',

  `p4` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',

  `entry` varchar(100) NOT NULL default '',

  PRIMARY KEY  (`id`),

  UNIQUE KEY `player1` (`player1`,`player2`,`player3`,`player4`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[premiso]

UNIQUE KEY (`player1`,`player2`,`player3`,`player4`)

 

If you were getting an error, it is good to post that error for next times reference.

[premiso]

On a side note, please do not double posts topics in separate forums. It is against our rules. Posting it in the correct forum, which you had right the first time, is all that you need to do. Moved this one to MySQL as well.