Re: [PHP] Crosstabs PHP [long]

2002-05-10 Thread Analysis Solutions
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

[PHP] Crosstabs PHP [long]

2002-05-07 Thread Jay Blanchard
I have the following code in page to query a 12,000,000 record DB for a crosstab; //query for RecordID list $qrid = SELECT DISTINCT RecordID ; $qrid .= FROM tblCrosstab ; $qrid .= ORDER BY RecordID ; $dbrid = mysql_query($qrid, $dbconnect) the second query is created on the fly, because I may