Guest Posted December 6, 2011 Posted December 6, 2011 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
jpweber Posted December 6, 2011 Posted December 6, 2011 (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 ...
♥Monika in Germany Posted December 6, 2011 Posted December 6, 2011 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 ...
jpweber Posted December 6, 2011 Posted December 6, 2011 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 ...
♥Monika in Germany Posted December 6, 2011 Posted December 6, 2011 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 ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.