install script wont create tables, need help

[HuntHerr]

I have a simple script to install a table in a database, but fails - any ideas?

<? 
$sqlhost = "localhost";  

$sqldb = "sqldb";     

$sqluser = "user1"; 	
$sqlpass = "pass1"; 	
mysql_connect($sqlhost, $sqluser, $sqlpass);
mysql_select_db($sqldb);


$query = "CREATE TABLE matches(
  id int(11) NOT NULL auto_increment,
  game varchar(25) NOT NULL default '',
  matchdate varchar(25) NOT NULL default '',
  league varchar(25) NOT NULL default '',
  opponent varchar(25) NOT NULL default '',
  map varchar(25) NOT NULL default '',
  fhscore varchar(25) NOT NULL default '',
  shscore char(25) NOT NULL default '',
  score char(25) NOT NULL default '',
  finalresult varchar(25) NOT NULL default '',
  roster varchar(100) NOT NULL default '',
  info longtext NOT NULL,
  PRIMARY KEY  (id,id)
) ";

echo "Creating Table <b>Matches</b>:  ";
$q = mysql_query($query) or die ("<font face=990000>Failed</font>");
echo "<font color=003366>Successful</font><br>";
 mysql_query($query); ?>

[jerdo]

Get rid of the second id in

PRIMARY KEY (id,id)

When I try that I get a duplicate column error, when I remove it and try your exact sql statement it works fine.

[HuntHerr]

thanks for the help