help please.. guys this is just the only problem in my program i cant print my data from sql..i need my thesis to finish soon..help please.. heres my code
<?php
require('fpdf.php');
$fullname = "";
echo $contractno = $_REQUEST['contractno'];
echo $sname = $_REQUEST['sname'];
echo $fname = $_REQUEST['fname'];
echo $mi = $_REQUEST['mi'];
echo $dob = $_REQUEST['dob'];
echo $cpprefix = $_REQUEST['cpprefix'];
echo $cpnum = $_REQUEST['cpnum'];
echo $eadd = $_REQUEST['eadd'];
include ('connect.php');
$str = "SELECT contractno,sname,fname,mi,dob,applno,cpnum,eadd WHERE ((contractno='".$contractno."')AND (sname='".$sname."') AND (fname='".$fname."') AND (mi='".$mi."') AND (dob='".$dob."') AND (applno='".$applno.'"));
echo $result = mysql_query($str,$db);
class PDF extends FPDF
{
function Header()
{
$this->Image('lifehead.jpg',25,10,150);
$this->SetFont('Arial','B',12);
$this->Cell(80);
$this->Ln(20);
}
}
$pdf=new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Arial','','8');
//for($i=1;$i<=40;$i++)
//(x,y)
$pdf->SetXY(40,10);
$pdf->Cell(10,73,'Planholder', $sname, $fname, $mi);
//$pdf->SetXY(69,10);
//$pdf->Cell(10,73);
$pdf->SetXY(72,10); //TO INDENT
$pdf->Cell(10,73,' Birthdate', $dob);
//$pdf->SetXY(136,10);
//$pdf->Cell(10,73, 'Contract Date');
$pdf->SetXY(40,10);
$pdf->Cell(10,95,'Contact number', $contractno);
$pdf->SetXY(42,10);
$pdf->Cell(10,110,'Application Number', $applno);
//$pdf->SetXY(69,10);
//$pdf->Cell(10,110);
$pdf->SetXY(72,10); //TO INDENT
$pdf->Cell(10,110,' Email Address', $eadd);
//$pdf->SetXY(95,10); //TO INDENT
//$pdf->Cell(10,110,' Contract Date');
$pdf->SetXY(40,10);
$pdf->Cell(10,177,'Conforme:');
$pdf->SetXY(48,10);
$pdf->Cell(10,195,'___________________');
$pdf->SetXY(56,10);
$pdf->Cell(10,202,'Planholder');
$pdf->SetXY(58,10);
$pdf->Cell(10,195,' _______________');
$pdf->SetXY(66,10);
$pdf->Cell(10,202,' Date');
$pdf->Output();
?>
