What table is the customer's company name saved at in the database?

28 Sep 2007, 11:32 PM

#1

Zen Follower

Join Date:: May 2007
Posts:: 136
Plugin Contributions:: 0

What table is the customer's company name saved at in the database?

Hello guys,
I’m working on a new mod, and I would like to know where the customer’s company name is saved at in the database, I looked in the zen_customers table but did not see it there, where would I find this field?
Thanks for the help guys.

29 Sep 2007, 12:01 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: What table is the customer's company name saved at in the database?

entry_company in the address_book table

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

29 Sep 2007, 12:45 AM

#3

illusionguy

Zen Follower

Join Date:: May 2007
Posts:: 136
Plugin Contributions:: 0

Re: What table is the customer's company name saved at in the database?

Cool, thanks DrByte

I will query the zen_address_book table instead of the zen_customers table thanks for the info.

29 Sep 2007, 1:55 AM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: What table is the customer's company name saved at in the database?

No ... you should probably query both, using a table join.
The address_book table is a many-to-one relationship to the customers table, keyed on address_book_id and customers_default_address_id

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

31 Dec 2007, 2:44 AM

#5

steveosupremo

New Zenner

Join Date:: Oct 2006
Posts:: 4
Plugin Contributions:: 0

Re: What table is the customer's company name saved at in the database?

What is the easiest way to get the customers company info from this table? and without going into too much detail I am looking to use this information in the shopping_cart.php file

and on a related question where do I find information on interfacing with the database. ie developer stuff.

thanks
Steve