[Resolved] Report generating

[bengt]

Hello.

I have a page on my site where the user can generate reports based on values from some different tables.

When generating this report it should creates a row in a table. This I know how to do.
The table will be like this:
id
reportname
field1name
field1value
field2name
field2value
...and so on

Then I want all the data stored in a file, how can I do that?
And then to retrieve it later for us in eks JPGraph.

[bastien]

if you want to store the data, you'd likely be better off storing the query that generated the data. Then you can recreate the report as needed.

Another option is to create the entire report as one variable

$report = "this report is ...";

while ($rows = mysql_fetch_array($result))
{
  $report .= $rows[0];
  ...
  $reports .= $rows[n];

}

echo $reports;

Then you can do anything you need with the report. Save it to a file, save it to a db entry as a blob, etc...

If its stricitly the data, then you can do much the same but setup the data to be stored in key:value pairs that you can easily parse.

[bengt]

I solved this by creating a row in a table(report)
With
id
reportname
field1
field2
field3

Stored the data separated by ; in a .txt file and use explode() to create the arrays I needed.

Thanx anyways

Bengt