stevemkrenz Posted January 18, 2005 Share Posted January 18, 2005 I installed the Puchase Order Number contribution and it said to use a SQL editor to add to the table.. Add these 3 fields to table orders by running these lines in phpmyadmin or what ever you prefer. # Add customers purchase orders values to each order ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value` ; ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name` ; ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number` ; . I couldnt get a editor to work so I opened the SQL file in HTML kit and added the lines... account_name varchar(32) , account_number varchar(20) , po_number varchar(12) , in the table. Then I loaded it onto the server. In the admin area, looking at the orders, it says Purchase order, but it does not say the customer number or name. Is there something I did wrong? Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.