Thread: 2 Address Lines
View Single Post
  #13  
Old 04-26-2004, 01:57 AM
  B00MER's Avatar 
B00MER B00MER is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Keller, TX (Cart-Lab.com)
Posts: 3,165
 

Default

Quote:
Originally Posted by rodneyw
Using phpMyAdmin you will need to modify your CUSTOMER table in the database.
Insert new field AFTER b_address with the name b_address2
Insert new field AFTER s_address with the name s_address2

Using phpMyAdmin you will need to modify your ORDERS table in the database.
Insert new field AFTER b_address with the name b_address2
Insert new field AFTER s_address with the name s_address2

Instead of doing this steps, in case you don't have phpmyadmin, you can use this SQL query in patch/upgrades in your X-Cart admin to achieve the same:

Code:
ALTER TABLE `xcart_customers` ADD `b_address2` VARCHAR( 64 ) NOT NULL AFTER `b_address` ; ALTER TABLE `xcart_customers` ADD `s_address2` VARCHAR( 64 ) NOT NULL AFTER `s_address` ;

Great documentation btw
__________________
Cart-Lab - 100+ Social Bookmarks for X-Cart.
Reply With Quote