Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    Feb 2007
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    err(121) creating table

    im trying to create a database in a php file.i am using Mysql 5.0.33 PHP 5.2.1

    this is the code i have in the php file

    PHP Code:
    $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
    Last edited by guelphdad; 02-27-2007 at 02:08 PM. Reason: added [php] and [/php] tags


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •