Jump to content

colours

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

colours's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I use Dreamweaver also to program my sites, but I think an easier way to achieve this would be this.... Goto your phpMyAdmin - select your appropriate database name, then in the SQL query window paste the contents of your insert.sql file which in this case is the following, CREATE TABLE comments ( COMMENT_ID int(11) NOT NULL auto_increment, FIRST_NAME varchar(50) default NULL, LAST_NAME varchar(50) default NULL, TELEPHONE varchar(20) default NULL, EMAIL varchar(50) default NULL, SUBMIT_DATE datetime default NULL, COMMENTS longtext, ANSWERED tinyint(4) default NULL, PRIMARY KEY (COMMENT_ID), KEY PRIMARY_KEY (COMMENT_ID) ) Press GO! and there you have it! the table "comments" will now be created for you with all the appropriate properties, i.e. varchar, int, longtext, etc... Thats the way I create my tables.... Surely though you could write your own script for creating tables from a web-form located locally on your workstation. Hope that helps.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.