Re: help on creating a CSV file on the fly and sending it over to the customer

Carlos: I have written a system almost identical to the one that you specify. It it a fairly easy to program in PHP, but you must think it through first. You are talking about applicaton design, not simple PHP coding, and that is something beyond the scope of this list. In response to your second question, CSV files are easy to produce, you just retrive the data, and write it out with a comma between each column in the result. It is just like building an html table, but you use "," between each cell, instead of "</td><td>", and just a CR-LF at the end of each row, rather than "</tr><tr>". I hope that this help. Thanks. Peter Bowen On Sun, 3 Dec 2000, Nando2 wrote: > Hello everyone, > > I would like to create a PHP script to do the following : > > It 's a order system that allows a certain user to select the orders and have the system > to write a CSV (a text file of the result query that has fields separated by ;) and then send it > over to the user through http. This user is the one that will process the order, not the buyers who > are actually entering the orders. > > 1) Allow this user to select orders by clicking checkboxes. The orders numbers would be > presented as a HTML table with checkboxes. Once the user clicks submit it would send through post > the order number so that a query could be executed to retrive all order data with the selected order > numbers. > > 2) Once the query is triggered the system would produce a text file on CSV format with the > query result an send it over to the user through http. > > Has anyone ever did something like this? Can anyone help me or give me any directions on how to > achieve it? > > Thank you very much, > > Carlos Fernando. >