$pdf = new FPDF();

$pdf->AddPage(L); // Querformat --> L weglassen = Hochformat

$pdf->SetFont('Arial','B',16);

$pdf->SetAuthor( 'www.AlienCollectors.com' );

$pdf->SetTitle( 'MyCollection www.AlienCollectors.com' );

$pdf->Cell(40,10,'My Collection');





$pdf->SetFont('Arial','IB',8);



$pdf->Cell(10,30,'',0,1);

$pdf->SetTextColor(210, 0, 0);



$pdf->Cell(30, 5,'CATEGORY NAME', 1, 0,L,0); 

$pdf->Cell(40, 5,'FIGURE NAME', 1, 0,L,0); 

$pdf->Cell(40, 5,'VARIANT', 1, 0,L,0);

$pdf->Cell(40, 5,'SERIE', 1, 0,L,0);

$pdf->Cell(40, 5,'MANUFACTURER', 1, 0,L,0);

$pdf->Cell(22, 5,'RETAILPRICE', 1, 0,L,0);

$pdf->Cell(25, 5,'RELEASEDATE', 1, 0,L,0);

$pdf->Cell(19, 5,'LIMITATION', 1, 0,L,0);

$pdf->Cell(22, 5,'EDITIONSSIZE', 1, 1,L,0);



if($result){

while($datensatz = mysql_fetch_assoc($result))

{

$pdf->SetFont('Arial','',8);

$pdf->SetTextColor(0, 0, 0);

$pdf->Cell(30, 5,''.trimlink($datensatz["Category Name"],27), 1, 0,L,0);

$pdf->Cell(40, 5,''.trimlink($datensatz["Figure Name"],27), 1, 0,L,0);

$pdf->Cell(40, 5,''.trimlink($datensatz["Variant"],27), 1, 0,L,0);

$pdf->Cell(40, 5,''.trimlink($datensatz["Series"],27), 1, 0,L,0);

$pdf->Cell(40, 5,''.trimlink($datensatz["Manufacturer"],27), 1, 0,L,0);

$pdf->Cell(22, 5,''.trimlink($datensatz["Retailprice"],20), 1, 0,L,0);

$pdf->Cell(25, 5,''.trimlink($datensatz["Releasedate"],20), 1, 0,L,0);

$pdf->Cell(19, 5,''.trimlink($datensatz["Limitation"],20), 1, 0,L,0);

$pdf->Cell(22, 5,''.trimlink($datensatz["Editionssize"],20), 1, 1,L,0);

}

}



$pdf->SetFont('Arial','B',9);

$pdf->Text( 20, 236, 'Grettings' );

$pdf->SetTextColor(210, 0, 0);

$pdf->Text( 20, 250, 'www.AlienCollectors.com' );





$pdf->Output( 'MyCollection www.AlienCollectors.com', 'I');