Yeah, that's about what I thought too.  Certainly looks like it would
work.  Depending on the size of the table you end up doing two fairly
large db calls, but that's gotta be faster and simpler than all the
other data manipulation.

You could then add "Into outfile blah blah", and get it all done at
once, right?

Andrew Hazen


-----Original Message-----
From: Jay Blanchard [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 02, 2002 9:47 AM
To: 'Andrew Hazen'; [EMAIL PROTECTED]
Subject: RE: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

[snip]
Fascinating.  But how do you build the SELECT?  Seems to me you would
first have to "SELECT RecordID FROM tblClass10" and then script an
iteration to build the whole series of IF clauses.  Or did I miss
something?
[/snip]

You could do that for the RecordID if you do not know what they are (I
knew
what RecordID's existed, so I could specifiy an IF statement for each).
If I
remember correctly you could even have SQL produce do the code for you.
In
PHP you could do it any number of ways (pseudocode follows - untested,
YMMV);

$query1 = "SELECT DISTINCT RecordID ";
$query1 .= "FROM tblFOO ";

$query2 = "SELECT RecordDate, ";
$db1 = mysql_query($query1, $dbconnect)
while($dbrow = mysql_fetch_object($db1)){
        $query2 .= "IF(RecordID=$dbrow->RecordID,count(*),0) AS
$dbrow->RecordID,
";
        }
$query2 .= "FROM tblFOO ";
$q11 .= "GROUP BY RecordDate ";

Now, IF THIS WORKS (I will repeat that I have not tested it), it would
be
very convenient. I may have made some small syntax errors, if I get the
chance I will try it later. If you try it and it works let me know.

Jay Blanchard



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to