Description:
------------
I'm unsure if I have the actual cause - but....

I'm working on a large report.  They would like for it to be in PDF.  So I'm using PDFLIB.  If all of the code is together - the PDF is generated with no problems.  Unfortunately, between the pdf_new() and then other pdf commands there is an SQL call to MySQL.  When that is finished the error I get back is:

PHP Fatal error:  Uncaught exception 'PDFlibException' with message 'pdf_open_file(): 6 is not a valid pdf object resource'

The #6 is the resource ID (if I put in echo statements to print out $myPDF it prints "6") of the PDF document.  So it is like PHP is closing out the PDF document (or maybe just dumping the resource info).

Reproduce code:
---------------
        $myPDF = pdf_new();
        pdf_open_file( $myPDF, "" );                        #   We use a "" if the output is coming
        pdf_begin_page( $myPDF, 11 * 72, 8.5 * 72 );        #   Paper resolution is 72dpi.  Always use inches.
        pdf_translate( $myPDF, 0, 8.5 * 72 );               #   Translate where the origin is to the top-left.
        pdf_scale( $myPDF, 1, -1 );                     #   Rescale everything.
        pdf_set_value( $myPDF, "horizscaling", -100 );  #   Set the horizontal scaling to -100%.

        $font = pdf_load_font( $myPDF, "Helvetica","iso8859-1", "" );
        if( $font ){ pdf_setfont( $myPDF, $font, -18.0 ); }

        $theString = "Palliative and Supportive Care Inpatient | Consult List";

        pdf_show_boxed( $myPDF, $theString, 20, 50, 500, 20, "center", "" );
        pdf_setcolor( $myPDF, "fill", "rgb", 0.9, 0.9, 0.9, 0.0 );
        pdf_rect( $myPDF, 20, 50, 300, 20 );
        pdf_fill_stroke( $myPDF );

        pdf_end_page( $myPDF );
        pdf_set_parameter( $myPDF, "openaction", "fitpage" );
        pdf_close( $myPDF );

        $buf = pdf_get_buffer( $myPDF );
        $len = strlen( $buf );
        header( "Content-Type:application/pdf" );
        header( "Content-Length:$len" );
        header( "Content-Disposition:inline; filename=DailyRpt.pdf" );
        echo $buf;
        pdf_delete( $myPDF );

Expected result:
----------------
The above code works so long as it is all together.  I get a single PDF page which reads "Palliative and Supportive Care Inpatient | Consult List".

Actual result:
--------------
However, if an SQL command is sent to the database between the "pdf_new()" and the "pdf_open_file()" commands, no PDF document is generated and Apache gives the above error.

Example SQL command:
    $sql = <<<END_OF_SQL
SELECT  distinct B.VISIT_TYPE, B.Patient_class, A.LAST_NAME, A.FIRST_NAME,
    A.MIDDLE_NAME, A.MRN, B.PC_MD, B.PC_FELLOW, B.PC_NP, B.ROOM,
    to_char( B.PC_ADMISSION_DATE, 'MM/DD/YYYY') as  VISITS_DATE, B.CONSULTING_MD,
    A.DOB, B.VISITID, B.PRK, B.PC_NP, N.LAST_NAME AS PC_FELLOW_LN,
    N.FIRST_NAME AS PC_FELLOW_FN, O.LAST_NAME AS PC_NP_LN, O.FIRST_NAME AS PC_NP_FN,
    B.VISITID, B.PRK, to_char( A.DOB, 'MM/DD/YYYY') AS ADOB,
    P.Last_Name as CONSULTING_MD_LAST_NAME, P.HOSPITAL_SERVICE_CD, B.VISIT_COMMENT
        FROM  Patients_VW A, Visits B, PALLIATIVE_PATIENTS L, EMPLOYEES_VW N, EMPLOYEES_VW O, PHYSICIANS_VW P
        WHERE  B.Care_Discharged_Date IS NULL
            AND  ( B.Patient_class = 1  OR  B.Patient_class = 5 )
            AND  B.PC_FELLOW = N.EMPLID( + )
            AND  B.PC_NP = O.EMPLID( + )
            AND  B.CONSULTING_MD = P.PHYSICIAN_ID( + )
            AND  B.PRK = A.PRK
            AND  B.PRK = L.PRK
        ORDER BY B.ROOM
END_OF_SQL;


NOTES:  This program already works and can produce an HTML report.  There are four sections to the report, thus, I have to produce four different pages in the PDF document before I can actually close it.  This was the first of the pages.  It took me four hours to figure out just what was going on.  (Commented out each command separately, then in groups, then started moving the commands around.  Finally got to the point of having all of the PDF commands together rather than some at the start of the program, and some in the middle.)

Ideas?