<?
$code=$_GET["code"];
$g=$_GET["g"];

include('db_config.php');

$sql="select * from $_data where ad_code='$code' and ad_usr='$g' order by ad_id desc";
$result=mysql_query($sql);

require('fpdf.php');
define('FPDF_FONTPATH','font/');
$pdf=new FPDF();
$pdf->AddFont('tfont','','SarabunBold.php');
$rw=1;
while ($db=mysql_fetch_array($result)) {
	
	if ($db[ad_code]=='F1' or $db[ad_code]=='Fo1') {
		$sp="กีฬา: $db[ad_sport]  จ.$db[ad_chw]";
	} else {
		$sp="$db[ad_duty]";
	}

	if (is_file("../$db[ad_pic]")) {
		$pict="../$db[ad_pic]";
	} else {
		$pict="../Images/user1_information.png";
	}

	$pdf->AddPage();
	$pdf->SetFont('tfont','',15);
//	$pdf->Image('bg_57.jpg',55,5,100,140,'','');
	$pdf->Image("$pict",62,60,30,38,'','');
//	$pdf->Image("$db[ad_code].jpg",124,8,25,30,'','');
	$pdf->Ln(94);
	$pdf->cell(48);
	$pdf->Cell(0,0,"$db[ad_id] $db[ad_name]",0,1,'L');
	$pdf->Ln(5);
	$pdf->cell(48);
	$pdf->Cell(0,0,"$sp",0,1,'L');	
	$rw++;
}
$pdf->Output("pdf/MyPDF.pdf","I");
?>