Background:
I have a shopping cart and using fedex as my shipping. Unfortunately, the shopping cart does not connect with fedex directly to print out the shipping labels, get tracking number and everything else, it just gives the rate of the shipment. I contacted fedex and they gave me a software to batch upload all orders at once, or individually. Problem, my cart does not export shipping info in csv, so I either have to go into the database every day to export and create a custom query in the format of fedexs csv uploader, or type each order out individually. I would rather not do either of those.

Prefer:
I would like to set up a web page in my general admin area where I could query the database from online and it spits out a straight csv file or a zipped csv file with the info requested. It took quite a few hours on my end, being ignorant to this whole programming thing, to make the initial query statement that needs to run..

SELECT orders_id, customers_company, customers_name,  delivery_street_address,   delivery_suburb,  delivery_city,  delivery_state,  delivery_country, delivery_postcode,  customers_telephone FROM  `gp_orders`  WHERE orders_id>147

What I need to be able to happen is the query of "orders_id>147" needs to be a text area that I type the number into. That is the first order of the day and I would type it in, that way I only get the orders of this day to spit out when I press the link or submit button.

And I know there are other carts out there that may do this, but I prefer this cart and it has a whole lot of other features.

Can someone help me put together this php page?

Thanks.

If I have you right, I believe all you will have to do is create a form/script that will do the query for you and create the csv. If you are using the phpmyadmin GUI follow the instructions on how to export a file, then just look at the phpmyadmin interface and look at the query it creates. Phpmyadming shows the query it used to produce the results. You then just use that query in your script to produce the csv.

Phpmyadmin allows you to create and export csv files and zip them also. Because phpmyadmin GUI is written in php, I believe you can view the query results of what you do in it.

Hope it helps.

in my experience with phpmyadmin the script is slightly off from what you need to plug into make it work - i.e. single quotes instead of double quotes - but mostly if I can't figure out how to do something I want to do I will try it in phpmyadmin and adjust the script when pasting it.

Or, you could look here which should be a big help to your cause. It is file manipulation, which can help you to make php create csv.