Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Where the heck is the customer's state stored?


NodsDorf

Recommended Posts

Posted

State as in US State.

 

I looked in table customers, customers_info, address_book and don't see it anywhere. Only a reference to customers_default_address_id in table customers. Then I can't find where the heck the default address's are stored.

 

I see the state on the orders, but I need to write an if statement for the accounts page and can't find anything to reference.

 

Thanks.

Posted

The state is int the address_book tabkle.

 

If they use the states drop down to pick a state/province it is put in the entry_zone_id column. If they type in a state/province that is not listed in the aones table the state/province is put into the entry_state column.

Archived

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

×
×
  • Create New...