1 Reply Latest reply: Oct 13, 2010 10:56 AM by David_Powers RSS

    create a table with php

    I Love Doing Websites Community Member

      Hello,

       

      I try to create the table 2010craftitems with this code, I run the page on the server but the table is not being created any ideas why?

       

      mysql_connect("servert", "dbname", "password") or die(mysql_error());
      mysql_select_db("dbname") or die(mysql_error());

       

      mysql_query("CREATE TABLE 2010craftitems (itemnum int(11) NOT NULL

       

      auto_increment,
        description varchar(255) NOT NULL,

       

      size varchar(50) default NULL,
        thumbnail varchar(100)

       

      default 'blank_thb.jpg',
        highbid varchar(10) default

       

      NULL,
        category varchar(100) default NULL,
        pattern

       

      varchar(100) default NULL,
        colors varchar(255) default

       

      NULL,
        madeby varchar(255) default NULL,
        quiltedby

       

      varchar(255) default NULL,
        tiedby varchar(255) default

       

      NULL,
        donatedby varchar(255) default NULL,
        largegif

       

      varchar(100) default 'blank_lg.jpg',
        thumb_width int(11)

       

      default '130',
        thumb_height int(11) default '110',

       

      gif_width int(11) default '467',
        gif_height int(11)

       

      default '390',
        PRIMARY KEY  (itemnum)
      )

       

      ENGINE=MyISAM  DEFAULT CHARSET=utf8
      )");
      Print "The  table has been created";
      ?>