where do I add new field to table, and where is SQL statement

[paulgg]

I am adding the e-way payment modules to accept credit card payments, part of the instructions are to:

 

 

 

c. Table Change: Add new field to "orders" table.

 

New Field: eway_id int(11) default 0 NOT NULL

 

 

 

SQL Statement:

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

ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')

 

 

Where do I add new field to table?

Where is the SQL statement?

[kgt]

Open phpMyAdmin.

 

Choose your oscommerce database.

 

Click the SQL tab along the top.

 

Paste this into the text box that appears:

ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')

 

Click Go.

 

Have a beer.

[paulgg]

Where do I access phpmyadmin? (I'm new at this)

 

I thought the instructions below were 2 seperate instructions, will copying the "ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')" into the SQL statement also cover the "New Field: eway_id int(11) default 0 NOT NULL

"

 

thanks for your previous reply.................

 

 

c. Table Change: Add new field to "orders" table.

 

New Field: eway_id int(11) default 0 NOT NULL

 

 

 

SQL Statement:

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

ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')

[Jan Zonjee]

Where do I access phpmyadmin? (I'm new at this)

That is something your ISP usually provides for accessing your database(s). Check their information or contact them for that.

I thought the instructions below were 2 seperate instructions, will copying the "ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')" into the SQL statement also cover the "New Field: eway_id int(11) default 0 NOT NULL

Yes.

 

You can find documentation on phpMyAdmin on their website.

[paulgg]

Thanks for your help-

 

I found phpmyadmin in Cpanel, and I will give it a go............................