Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MYSQL HELP


Guest

Recommended Posts

Posted

How do it?

 

1. MYSQL changes to orders table

 

ALTER TABLE orders ADD giftMethod varchar(20) NOT NULL default '' AFTER cc_expires;

ALTER TABLE orders ADD giftCard boolean NOT NULL default 0 AFTER giftMethod;

ALTER TABLE orders ADD giftMessage varchar(150) NOT NULL default '' AFTER giftCard;

 

D:??? iits for install a new feature :C

Posted

(1) Go to your website's Control Panel. Login.

(2) Click on the phpmyadmin link/icon

(3) Once in phpmyadmin, click on the SQL link

(4) Copy and paste the SQL dump:

ALTER TABLE orders ADD giftMethod varchar(20) NOT NULL default '' AFTER cc_expires;

ALTER TABLE orders ADD giftCard boolean NOT NULL default 0 AFTER giftMethod;

ALTER TABLE orders ADD giftMessage varchar(150) NOT NULL default '' AFTER giftCard;

into the box

(5) Execute the query

(6) Exit the Control Panel

(7) Refresh your web browser

 

Hope this helps.

Jason

 

Simple 1-2-3 Intructions on how to get, install and configure SSL

 

The Google Sandbox explained

 

Simple to follow instructions on how to change the look of your OSC

 

How To Make A Horrible OSC Website

 

my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP

 

my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...

Posted

in your hosts control panel, go to your database section and open the phpmyadmin database manager for your database. click on the sql tab and copy your 3 commands in.

 

when adding new modules, you will need to work on your database in many cases. it would be a good idea to pick up a book or online tutorials on the topic ...

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Posted

Monika didn't tell me to plug this, but I feel obligated to. You will have to get used to running database queries, and you should buy Monika's book, because she's a lot smarter than any of us, and she's a worldy expert on databases.

Jason

 

Simple 1-2-3 Intructions on how to get, install and configure SSL

 

The Google Sandbox explained

 

Simple to follow instructions on how to change the look of your OSC

 

How To Make A Horrible OSC Website

 

my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP

 

my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...

Posted

thx jason ... but you should tell people that it's not a book on phpmyadmin or databases in general ;-)

 

the OP will need basic knowledge on the main tools first!

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Archived

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

×
×
  • Create New...