I'm trying to export a list of arrays to Excel in order to create a spreadsheet. Basically, we enter a new campaign and select a list of customers that want to be a part of the campaign. What is then generated is a List that includes the title of the campaign, all the customer #'s that are included in the campaign, the list of the dealers, and the last column is their URLs. I have an Export button created, but am not sure how to pass these arrays through the URL, using a query string. The list is stored in the database, but the Customer Numbers and the URLs are being pulled from a different table based on the Customers chosen. So I am trying to avoid calling to multiple tables in the database to accomplish this. Is there an easy way to accomplish passing these values over to Excel?
I have tried the following and it wasn't working:
exportCampaign.php?promo_list&customer_num[]&dealer_ids[]&guid[]