Forums / Setting Up Categories, Products, Attributes / Combining Multiple Database Customer Tables

Combining Multiple Database Customer Tables

Views: 2,421

Results 21 to 23 of 23
12 Mar 2013, 10:13 PM
#21
abcschooldr avatar

abcschooldr

New Zenner

Join Date:
Feb 2012
Posts:
77
Plugin Contributions:
0

Combining Multiple Database Customer Tables

Maybe this is a stretch....but you have been very helpful. Have you heard of creating a 'view' on the database server to present the desired information as if it were on one table? Do you think this is a good question for my server host, or have you heard of anyone doing this with the Zen-cart database?

12 Mar 2013, 10:33 PM
#22
abcschooldr avatar

abcschooldr

New Zenner

Join Date:
Feb 2012
Posts:
77
Plugin Contributions:
0

Re: Combining Multiple Database Customer Tables

What is the orders_products_id in the zen_orders_products table? Is that just randomly generated?
Attachment 12139

12 Mar 2013, 11:41 PM
#23
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Combining Multiple Database Customer Tables

What is the orders_products_id in the zen_orders_products table
They are assigned sequentially

If 141 was the last order - place another one and it will be 142

Zen-Venom Get Bitten