Hi
ADOdb has a crosstab function that generates the sql for you. This is a
utility function, so you do not need to use the rest of ADOdb if you don't
want to.
Download: http://php.weblogs.com/adodb
Docs: http://phplens.com/lens/adodb/readme.htm#pivot
"Opec Kemp" <[EMAIL PROTECTED]> wrote in mes
Hi,
I don't think you can do that with MS SQL, it doesn't support TRASFORN, I
think that's strictly Access syntax. MS SQL 7 and up does have ROLLUP etc
but that's part of the OLAP service, which you will only get if you have
Enterprise edition (read $$ :)).
The easiest way to get out of this