Combining Multiple Database Customer Tables

[abcschooldr]

I need the customer's email address, order date/time, name, product ordered, and address to be in a single table. Is there a way to combine multiple items into a new table that can be added to the database?

zen_address_book lists name and address
zen_customers_info lists customers_info_date_account_created
zen_customers lists email address
zen_customers_basket lists product id
zen_products_description lists product id and name of product

[kobra]

What business objective are you attempting to solve??

Where would this information need to be accessible from?

[schoolboy]

If you are trying to EXTRACT that data, then there is no need to create new tables / fields... Just write a script that gathers it all up and produces it in the output you desire.

[abcschooldr]

Thank you for the quick replies! I am connecting the ZenCart database to Moodle external database authentication and enrollment. Moodle will only allow me to connect to 1 table. My customers do not create an account in ZenCart. I want to use their email address as a login user name and their zip code as a password. These are in 2 different tables.
Next I want that same table to list the correct course ordered. This is in a 3rd table. I also want the statutory required minimum time to start when they order.

[kobra]

.Moodle will only allow me to connect to 1 table

Maybe you should be asking there about connecting to more than one table

[abcschooldr]

I did. Without customization, everything needs to be in 1 table.

[abcschooldr]

It seems like everything is always interconnected. If I create a new table in phpMyAdmin and add 6 or so columns...pulling info from other tables, will I bring down the whole system? Or will it have no effect?

[kobra]

If I create a new table in phpMyAdmin and add 6 or so columns...pulling info from other tables, will I bring down the whole system?

You can do this

Or will it have no effect

Without code to populate these records in the new table I suspect there will be no effect

[gjh42]

You could write a script to copy the required info from the original tables to your new moodle table; but every time there is a new order (or a customer updates some information) your table will be out of date. You need some sort of auto-updating written into every function that affects the relevant fields, which is a significant amount of custom coding. Depending on how your moodle table gets used, it might be feasible to run the updating script every time that table is accessed. No matter what, you will need custom coding written by somebody. Will it be more cost-effective and efficient in the long run to code for this continual updating, or to get code to use the existing tables?

[abcschooldr]

Thank you! I didn't realize that zen_orders was a more comprehensive table in the database, that included most of what I wanted. As black belt suggested....that would be the table to use and maybe add to.