Duplicate DB entry controls

[webweever]

I need some sort of PHP control to ensure a user cannot create more than one list in the table below with the same name, what is the best way to do this?

CREATE TABLE `lists` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) collate latin1_general_ci NOT NULL,
  `dt` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
);

[laserlight]

Declare that column as UNIQUE.

[webweever]

A UNIQUE column would mean it's UNIQUE for all users correct? I need the list name to be unique per users, meaning user1 could have a list named tuesday and so could user2 but neither user1 or user2 could have 2 lists named tuesday.

[bradgrafelman]

So then add the 'user_id' column to that UNIQUE index as well.