<?
$id=$_GET["id"];
include('db_config.php');
$sql="select * from $_data where ad_id='$id' and ad_pic<>'Images/user1_information.png' 
 order by ad_sport,ad_id";
$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]";
	}

	$pdf->AddPage();
	$pdf->SetFont('tfont','',15);
//	$pdf->Image('bg_57.jpg',55,0,100,140,'','');
	$pdf->Image("../$db[ad_pic]",62,59,31,38,'','');
//	$pdf->Image("$db[ad_code].jpg",124,8,25,30,'','');
	$pdf->Ln(91);
	$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");

?>