[thelist] MySQL to Excel Problem

[Jay Blanchard]

[snip]
/path/to/php_to_excel.php/excel.xls
[/snip]

OK, that solves that problem and is easy to implement. The problem I have
now is creating pivot tables from the information. I'll use my previous
example;

SELECT RecordID, RecordDate, count(*) AS Quantity
FROM tblFOO
Group By RecordID, RecordDate

It returns;
+----------+------------+----------+
| RecordID | RecordDate | Quantity |
+----------+------------+----------+
| 100101   | 2002-03-21 |     6675 |
| 100101   | 2002-03-22 |     6794 |
| 100101   | 2002-03-23 |     2916 |
| 100101   | 2002-03-24 |     1215 |
| 100101   | 2002-03-25 |     6152 |
| 100101   | 2002-03-26 |     5398 |
+----------+------------+----------+

as expected (Only a subset here, there are hundreds of rows). I want to
place this data like this in an Excel table (bad ascii art example to
follow);

+------------+--------+--------+--------+
| RecordID   | 100101 | 100120 | 100131 |
+------------+--------+--------+--------+
| Date       |        |        |        |
+------------+--------+--------+--------+
| 2002-03-01 |        |     12 | 130101 |
+------------+--------+--------+--------+
| 2002-03-21 |   6675 |        |   1113 |
+------------+--------+--------+--------+
| 2002-03-22 |   6794 |    287 |  29045 |
+------------+--------+--------+--------+
| 2002-03-23 |   2916 |      6 | 233427 |
+------------+--------+--------+--------+

RecordID along the top row, dates down the side, quantities at the
intersection that they belong.

Importing the original table into Excel is no big deal, but getting the
table to pivot form is a nasty bit of business.

I did run seperate queries for RecordID and did a while loop to place them
as column heads, likewise with RecordDate to place in the first column of
each row. Could I write the query out to an array and then place the values
properly? I am at a loss here.

Thanks!

Jay