Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


paulgg

Recommended Posts

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?

Link to comment
Share on other sites

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')

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...