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 a

[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