error creating table???

[aconite]

im trying to create a database in a php file.

this is the code i have in the php file

 

$con = mysql_pconnect("127.0.0.1","root","12345");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

 

if (mysql_query("CREATE DATABASE mydatabase",$con))

  {

  echo 'Database created  ';

  }

else

  {

  echo "Error creating database: " . mysql_error();

  }

 

 

if(!mysql_select_db("mydatabase"))

{

die('Could not select database: mydatabase ' . mysql_error());

}

 

echo "Database selected    ";

 

if (mysql_query("CREATE TABLE customer

                            (f_name VARCHAR(15) NOT NULL,

    l_name VARCHAR(15) NOT NULL,

                              phone  VARCHAR(11) ,

                              account INT UNSIGNED PRIMARY KEY)")

  )

{

  echo 'table created';

  }

else

  {

  echo "  Error creating table: " . mysql_error();

  }

 

when i view this file in the browser i get

 

Database created Database selected Error creating table: Can't create table '.\mydatabase\customer.frm' (errno: 121)

 

any idea wht the prob is??

I did some reading and found it might have something to do with InnoDB. but i dont know what that is .If that is the prob can someone please explain InnoDB concept

[fenway]

That is a strange error... hmmm.