4 replies to this topic

[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]

paulgg, on May 20 2006, 12:19 AM, said:

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.

Quote

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............................