thdt98 Posted May 3, 2005 Share Posted May 3, 2005 Welcome to this thread for this new contribution. New feature: - Export to Excel in CVS format Quote Link to comment Share on other sites More sharing options...
zeav Posted May 13, 2005 Share Posted May 13, 2005 First off, This looks like an amazing contribution and I thank you for your time coding it. I'm pretty good with PHP but I need a bit of help with the first step: 1. add a table in ( database ) ALTER TABLE `products` ADD `products_price_cost` decimal(10,2) default NULL AFTER `products_price`; How exactly is that done? I believe it involves going into phpMyAdmin but I have no clue what to do after that. Thanks for all any help in advance. Quote Link to comment Share on other sites More sharing options...
thdt98 Posted May 13, 2005 Author Share Posted May 13, 2005 Yes you are right you have to go into phpMyadmin. You have to open a query window (SQL button for instance) and placing into it the code 'Alter.....' and press go. The table should added. I think the best is to have a go. When I started last year I knew nothing in mySQL and php. I learned by try and error and with those forums. Maybe my install might be a little difficult for someone with no experience. Perhaps the contrib margin 2.6 would be easier. Anyway give it a go. Quote Link to comment Share on other sites More sharing options...
zeav Posted May 13, 2005 Share Posted May 13, 2005 thanks for that, I think I did it right the first time I tried because this is the error it gives me now: Error SQL-query: ALTER TABLE `products` ADD `products_price_cost` decimal( 10, 2 ) default NULL AFTER `products_price` MySQL said: Documentation #1060 - Duplicate column name 'products_price_cost' Quote Link to comment Share on other sites More sharing options...
thdt98 Posted May 13, 2005 Author Share Posted May 13, 2005 Yes you did it twice I guess. Check if you have 2 table with the same name, if it is the case erease one. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.