need help, how do i create a table in a database

[isthiskene]

i want to install something on my osc ive done everything except for the first step (haha) but seriously i am a novice at this and for most of you this might very simple but if someone can explain to me how to perfom this task below i will greatly appreciate it, thanks

 

the main reason am even doing this is so i can beable to add text to my shipping/return and condition of use page on my website www.kennykicks.com, because everytime i add alot of text to it it gives me an error message but if i add alittle text it is okay so am really confused about that so i guess installin this would help me by pass wutever the problem is, thanks

 

 

INSTALLATION

-----------------------------------------------------------------------------------

Create a new table in your database:

 

DROP TABLE IF EXISTS `pages`;

CREATE TABLE `pages` (

`pages_id` int(11) NOT NULL auto_increment,

`pages_title` varchar(64) NOT NULL default '',

`pages_html_text` text,

`sort_order` int(3) default NULL,

`status` int(1) NOT NULL default '1',

PRIMARY KEY (`pages_id`)

) TYPE=MyISAM AUTO_INCREMENT=9 ;

 

Insert the sample data:

 

INSERT INTO `pages` VALUES (1, 'Index', 'Put here your Index (front page) information.', 0, 1);

INSERT INTO `pages` VALUES (2, 'About Us', 'Put here your About Us information.', 1, 1);

INSERT INTO `pages` VALUES (3, 'Conditions', 'Put here your Conditions of Use information.', 1, 1);

INSERT INTO `pages` VALUES (4, 'Contact Us', 'Put here extra Contact Us information that will apear above the normal Contact form.', 1, 1);

INSERT INTO `pages` VALUES (5, 'Privacy', 'Put here your Privacy information.', 1, 1);

INSERT INTO `pages` VALUES (6, 'Shipping & Returns', 'Put here your Shipping & Returns information.', 1, 1);

 

Alter pages table

alter table `pages` add intorext char(1);

alter table `pages` add externallink varchar(255);

[ozcsys]

i want to install something on my osc ive done everything except for the first step (haha) but seriously i am a novice at this and for most of you this might very simple but if someone can explain to me how to perfom this task below i will greatly appreciate it, thanks

 

the main reason am even doing this is so i can beable to add text to my shipping/return and condition of use page on my website www.kennykicks.com, because  everytime i add alot of text to it it gives me an error message but if i add alittle text it is okay so am really confused about that so i guess installin this would help me by pass wutever the problem is, thanks

INSTALLATION

-----------------------------------------------------------------------------------

Create a new table in your database:

 

DROP TABLE IF EXISTS `pages`;

CREATE TABLE `pages` (

  `pages_id` int(11) NOT NULL auto_increment,

  `pages_title` varchar(64) NOT NULL default '',

  `pages_html_text` text,

  `sort_order` int(3) default NULL,

  `status` int(1) NOT NULL default '1',

  PRIMARY KEY  (`pages_id`)

) TYPE=MyISAM AUTO_INCREMENT=9 ;

 

Insert the sample data:

 

INSERT INTO `pages` VALUES (1, 'Index', 'Put here your Index (front page) information.', 0, 1);

INSERT INTO `pages` VALUES (2, 'About Us', 'Put here your About Us information.', 1, 1);

INSERT INTO `pages` VALUES (3, 'Conditions', 'Put here your Conditions of Use information.', 1, 1);

INSERT INTO `pages` VALUES (4, 'Contact Us', 'Put here extra Contact Us information that will apear above the normal Contact form.', 1, 1);

INSERT INTO `pages` VALUES (5, 'Privacy', 'Put here your Privacy information.', 1, 1);

INSERT INTO `pages` VALUES (6, 'Shipping & Returns', 'Put here your Shipping & Returns information.', 1, 1);

 

Alter pages table

alter table `pages` add intorext char(1);

alter table `pages` add externallink varchar(255);

<{POST_SNAPBACK}>

 

In your hosting control panel go to phpmyadmin-> choose your database-> click on the sql tab-> copy the above sql info in the the field -> click on go. You are done. You should backup your database in the osC admin before making the changes just in case something goes wrong.