Re: Crosstabs & PHP [long]

Hi Jay: I've been meaning to examine your code and post a substantive reply, but I've been overloaded with other stuff. In lieu of that, take a look at my SQL Solution class at http://www.sqlsolution.info/ It has a function that takes a regular query string and creates a transform output like a spreadsheet. No need to create a temporary table, as it seems you were doing. Enjoy, --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409