This should have been a very simple export of data from the database, but there is a section that requires querying multiple tables to get the correct data.
The data is from a shopping cart and the table format can't be changed. I need someone experienced in mysql and php to help work out the couple pieces of data to be pulled that that is scattered in more than one table of the database.
As an example, the purchase order number is 5. That id number needs to be used to query a variation table, then that data is used to get the actual item's id number.