Overskrift til kolonner i pdf-dokumenter

Jeg har et script, som skal udtrække data fra min database til et pdf-dokument.

Overskrifterne til kolonnerne kommer imidlertid til at ligge i bunden af dokumentet.

Er der nogen der har forslag?

<?php

require('fpdf.php');

//Connect to your database
include("conn.php");

//Create new pdf file
$pdf=new FPDF();

//Disable automatic page break
$pdf->SetAutoPageBreak(false);

//Add first page
$pdf->AddPage();

//set initial y axis position per page
$y_axis_initial = 25;

//print column titles for the actual page
$pdf->SetFillColor(232,232,232);
$pdf->SetFont('Arial','B',12);
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Cell(30,6,'Fernisering',1,0,'L',1);
$pdf->Cell(30,6,'Sidste',1,0,'L',1);
$pdf->Cell(100,6,'Udstilling',1,0,'C',1);

$y_axis = $y_axis + $row_height;

//Select the Products you want to show in your PDF file
#$result=mysql_query('select sn,fernisering,sidste,titel,kortbeskr,langbeskr,filnavn from $branch ORDER BY fernisering',$link);
$result=mysql_query("select * from emp_branch ORDER BY fernisering");
//initialize counter
$i = 0;

//Set maximum rows per page
$max = 25;

//Set Row Height
$row_height = 6;

while($row = mysql_fetch_array($result))
{
    //If the current row is the last one, create new page and print column title
    if ($i == $max)
    {
        $pdf->AddPage();

        //print column titles for the current page
        $pdf->SetY($y_axis_initial);
        $pdf->SetX(25);
        $pdf->Cell(30,6,'Fernisering',1,0,'L',1);
        $pdf->Cell(30,6,'Sidste',1,0,'L',1);
        $pdf->Cell(100,6,'Udstilling',1,0,'L',1);
       
        //Go to next row
        $y_axis = $y_axis + $row_height;
       
        //Set $i variable to 0 (first row)
        $i = 0;
    }

    $fernisering = $row['fernisering'];
    $sidste = $row['sidste'];
    $langbeskr = $row['langbeskr'];

    $pdf->SetY($y_axis);
    $pdf->SetX(25);
    $pdf->Cell(30,6,$fernisering,1,0,'L',1);
    $pdf->Cell(30,6,$sidste,1,0,'L',1);
    $pdf->Cell(100,6,$langbeskr,1,0,'L',1);

    //Go to next row
    $y_axis = $y_axis + $row_height;
    $i = $i + 1;
}

//mysql_close($link);

//Create file
$pdf->Output();
?>