export do xls blad wysłanych nagłówków Opcje

[john_doe]

Witajcie,

mam sobie plik z zapytaniami

[PHP] pobierz, plaintext 
<?php
 
// obi dom i ogr󤠳ummary
$OBI_TRANSACTION_PER_MONTH = 
"
 
    SELECT 
        CDN.NumerDokumentuTRN ( TRN_GIDTYP, TRN_SPITYP, TRN_TRNTYP, TRN_TRNNUMER, TRN_TRNROK, TRN_TRNSERIA ) AS DOKUMENT,
        CDN.TSTODATE(TRN_DATA2, 0) AS [DATA WYSTAWIENIA],
        SUM(TRE_KSIEGOWANETTO) AS NETTO
        
    FROM CDN.TRANAG INNER JOIN CDN.TRAELEM ON TRN_GIDTYP = TRE_GIDTYP AND TRN_GIDNUMER = TRE_GIDNUMER
                    INNER JOIN CDN.KNTKARTY ON TRN_KNPTYP = KNT_GIDTYP AND TRN_KNPNUMER = KNT_GIDNUMER
                    
    WHERE 
                KNT_GIDNUMER = $kksId
        AND CDN.TSTODATE(TRN_DATA2,0) 
            BETWEEN CDN.YMD($dataOd[2], $dataOd[1], $dataOd[0])
            AND     CDN.YMD($dataDo[2], $dataDo[1], $dataDo[0])
        AND     TRN_GIDTYP IN ( 2033, 2041, 2037, 2045 )    
 
    GROUP BY 
        CDN.NumerDokumentuTRN ( TRN_GIDTYP, TRN_SPITYP, TRN_TRNTYP, TRN_TRNNUMER, TRN_TRNROK, TRN_TRNSERIA ),
        CDN.TSTODATE(TRN_DATA2, 0)
    ";
 
?>
[PHP] pobierz, plaintext 

oraz plik, w którym dokonuje exportu do Excela

[PHP] pobierz, plaintext 
<?php
 
$dataOd = explode("-", $_GET['from']);
$dataDo = explode("-",  $_GET['to']);
$kksId  = $_GET['id'];
 
include('../../db/smplConnection.php');
include('../../querries/querries.php');
 
 
$exportXls = mssql_query( $OBI_TRANSACTION_PER_MONTH );
 
// set variables
$header = "";
$data   = "";
 
for ( $i = 0 ; $i <= 2 ; $i++ ) 
{
    $header .= mssql_field_name( $exportXls, $i ) . "\t";   
}
 
while( $row = mssql_fetch_row( $exportXls ) ) 
{
        $data .= $row[0] . " \t" . $row[1] . " \t" . $row[2] . " \n";
}
 
 
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=exportKrystianowy.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data"; 
 
 
?>
[PHP] pobierz, plaintext 

dostaje takie warningi


Warning: Cannot modify header information - headers already sent by (output started at C:\wamp\www\malfarb_analyzer\querries\querries.php:1) in C:\wamp\www\malfarb_analyzer\analizy\obi\xlsExport.php on line 28

Warning: Cannot modify header information - headers already sent by (output started at C:\wamp\www\malfarb_analyzer\querries\querries.php:1) in C:\wamp\www\malfarb_analyzer\analizy\obi\xlsExport.php on line 29

Warning: Cannot modify header information - headers already sent by (output started at C:\wamp\www\malfarb_analyzer\querries\querries.php:1) in C:\wamp\www\malfarb_analyzer\analizy\obi\xlsExport.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at C:\wamp\www\malfarb_analyzer\querries\querries.php:1) in C:\wamp\www\malfarb_analyzer\analizy\obi\xlsExport.php on line 31

gdzie w pliku querries wysyłam coś do przeglądarki?(IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif) ? co tu jest nie tak?

pozdrawiam

[nospor]

masz albo pustą linie lub spacje przed <?
lub masz BOM.

BYlo MILION razy!