help! question about using fpdf

im using PHP and MySQL

i have a receipt format to be followed, so the printout must fill the receipt exactly.

but i have a problem

heres the format

Code:

---

customer info

product order1          qty1          unitprice1     
product order2          qty2          unitprice2
product order3          qty3          unitprice3
product order4          qty4          unitprice4
product order5          qty5          unitprice5
product order6          qty6          unitprice6
product order7          qty7          unitprice7
product order8          qty8          unitprice8
product order9          qty9          unitprice9


prepared by:                  total:          <------here's my problem (this line must be fixed)

---

the receipt format can have up to 9 product order, if i input 9 products the printout is exact to the receipt, but if i input below 9 product the line where PREPARED BY: and TOTAL: moves up!


is there anyway that cell can be fixed? so it will be exact on the receipt. im using fpdf 1.53

here's my code

PHP Code:

---

<?php

    $invoice_no=$_GET['invoice_no'];
    
    include("conn_db.php");
    require('fpdf.php');
    
    
    $result = mysql_query ("SELECT date, invoice_no, customer, address, business_style, tin, total_sales, tax, total_amount, prepared_by, approved_by, released_by
                        FROM cash_invoice AS ci
                        WHERE ci.invoice_no = '$invoice_no'");

while($row = mysql_fetch_array($result))
{
                $date = $row["date"];
                $invoice_no = $row["invoice_no"];
                $customer = $row["customer"];
                $address = $row["address"];
                $business_style = $row["business_style"];
                $tin = $row["tin"];
                $total_sales = $row["total_sales"];
                $tax = $row["tax"];
                $total_amount = $row["total_amount"];
                $prepared_by = $row["prepared_by"];
                $released_by = $row["released_by"];
                $approved_by = $row["approved_by"];
                }
                
    $pdf=new FPDF();
    $pdf->Open();
    $pdf->AddPage();
    
    
        $pdf->SetFont('Times','B',15);
        $pdf->Cell(200,25,$invoice_no,0,0,'R');
        $pdf->ln(30);
        $pdf->Cell(10);
        $pdf->Cell(30,20,$customer,0,0,'L');
        $pdf->Cell(160,20,$tin,0,0,'R');
        $pdf->ln(10);
        $pdf->Cell(10);
        $pdf->Cell(30,25,$address,0,0,'L');
        $pdf->Cell(80,25,$business_style,0,0,'R');
        $pdf->Cell(80,25,$date,0,0,'R');
        $pdf->ln(5);
        $pdf->SetFont('Arial','B',11);
        
        $prod ="SELECT p.description, ip.qty, ip.unit_price, ip.total, ip.invoice_no
                    FROM invoice_products as ip
                    LEFT JOIN product as p on p.prod_id = ip.prod_id
                    LEFT JOIN cash_invoice as ci ON ci.invoice_no = ip.invoice_no
                    WHERE ip.invoice_no='$invoice_no'";
            
            $result=mysql_query($prod);
            
            
            while($row=mysql_fetch_array($result))
{


$description=$row["description"];
$qty=$row["qty"];
$unit_price=$row["unit_price"];
$total=$row["total"];
        
        $pdf->ln(4);
        $pdf->Cell(20,50,$qty,0,0,'L');
        $pdf->Cell(120,50,$description,0,0,'L');
        $pdf->Cell(40,50,$unit_price,0,0,'L');
        $pdf->Cell(30,50,$total,0,0,'L');
        
    }
        $pdf->ln(5);
        $pdf->Cell(5,80,$prepared_by,0,0,'L');
        $pdf->Cell(80,80,$approved_by,0,0,'R');
        $pdf->Cell(35,80,$released_by,0,0,'R');
        
        $pdf->ln(5);
        $pdf->SetFont('Arial','B',12);
        $pdf->Cell(10);
        $pdf->ln(5);
        $pdf->Cell(200,50,$total_sales,0,0,'R');
        $pdf->ln(5);
        $pdf->Cell(200,50,$tax,0,0,'R');
        $pdf->ln(5);
        $pdf->Cell(200,50,$total_amount,0,0,'R');

$pdf->Output();
    
?>

---

thx! hope someone help me

Why don't you just fill the extra rows with whitespace?

fill with whitespace? how? will i make a condition? help me please'

Why don't you just create a variable that increments by 1 each reading of the database. Then, you know exactly how many rows were printed. Then, just print enough blank rows to equal 9.

or can i use a function footer so that that line will be fixed? is that possible? how?