Two UNIQUE colums.

[curlious]

I am trying to create a table with two colums that are UNIQUE is this possible

//this works but only one unique column
$table = "`".$_POST['linkCatagory']."`";
  	$query = "CREATE TABLE IF NOT EXISTS " . $table . " (
 	  id INT(3) NOT NULL auto_increment,
 	  linkText VARCHAR(128) NOT NULL UNIQUE,
  	  url VARCHAR(256) NOT NULL,
  	  linkComment MEDIUMTEXT NOT NULL,
  	  PRIMARY KEY (id)
   	)";

//the following two attempts to do this failed
$table = "`".$_POST['linkCatagory']."`";
  	$query = "CREATE TABLE IF NOT EXISTS " . $table . " (
 	  id INT(3) NOT NULL auto_increment,
 	  linkText VARCHAR(128) NOT NULL UNIQUE,
  	  url VARCHAR(256) NOT NULL UNIQUE,
  	  linkComment MEDIUMTEXT NOT NULL,
  	  PRIMARY KEY (id)
   	)";

$table = "`".$_POST['linkCatagory']."`";
  	$query = "CREATE TABLE IF NOT EXISTS " . $table . " (
 	  id INT(3) NOT NULL auto_increment,
 	  linkText VARCHAR(128) NOT NULL UNIQUE,
  	  url VARCHAR(256) NOT NULL,
  	  linkComment MEDIUMTEXT NOT NULL,
  	  PRIMARY KEY (id)
         UNIQUE(linkText, url)
   	)";

[richie]

You can you have as many unique columns as you want.

But your problem is that you're exceeding allowed length for varchar, which is 255.

Try this:

$table = "".$_POST['linkCatagory']."";
$query = "CREATE TABLE IF NOT EXISTS " . $table . " (
id INT(3) NOT NULL auto_increment,
linkText VARCHAR(128) NOT NULL UNIQUE,
url VARCHAR(255) NOT NULL UNIQUE,
linkComment MEDIUMTEXT NOT NULL,
PRIMARY KEY (id)
) ";