<?
include('db_config.php');
mysql_query("truncate table card4");

$sql="select * from $_data where ad_chw='$chw' and ad_code='$code' and ad_pic<>'Images/user1_information.png' order by ad_sport,ad_id";
$result=mysql_query($sql);
$rw=1; $row=1;
while ($db=mysql_fetch_array($result)) {
	if ($rw==1) {	
		$sql1="insert into card4 set cd_id='$row',cd_code='$db[ad_code]', 
			id1='$db[ad_id]',name1='$db[ad_name]', 			sp1='$db[ad_sport]',chw1='$db[ad_chw]',pic1='$db[ad_pic]' "; 
		mysql_query($sql1);
	} elseif ($rw==2)  {
		$sql1="update card4 set id2='$db[ad_id]',name2='$db[ad_name]', 
			sp2='$db[ad_sport]',chw2='$db[ad_chw]',pic2='$db[ad_pic]' where cd_id='$row' "; 
		mysql_query($sql1);
	} elseif ($rw==3)  {
		$sql1="update card4 set id3='$db[ad_id]',name3='$db[ad_name]', 
			sp3='$db[ad_sport]',chw3='$db[ad_chw]',pic3='$db[ad_pic]' where cd_id='$row' "; 
		mysql_query($sql1);
	} elseif ($rw==4)  {
		$sql1="update card4 set id4='$db[ad_id]',name4='$db[ad_name]', 
			sp4='$db[ad_sport]',chw4='$db[ad_chw]',pic4='$db[ad_pic]' where cd_id='$row' "; 
		mysql_query($sql1);
		$rw=0; $row++;
	}
	$rw++;
}

$sql="select * from card4";
$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[cd_code]=='F') {
		$bg='bgf.jpg';
	} elseif($db[cd_code]=='Fo') { 
		$bg='bgfo.jpg';
	}

	$pdf->AddPage();
	$pdf->SetFont('tfont','',16);
	$pdf->Image("$bg",0,0,102,140,'','');
	$pdf->Image("../$db[pic1]",8,65,30,35,'','');
	if ($db[pic2] !='') {	
		$pdf->Image("$bg",102,0,102,140,'','');
		$pdf->Image("../$db[pic2]",107,65,30,35,'','');
		$sp2="กีฬา: $db[sp2] จ.$db[chw2]";
	} else {
		$sp2="";
	}
	$pdf->Ln(96);
	$pdf->cell(1);
	$pdf->Cell(0,0,"$db[id1] $db[name1]",0,1,'L');
	$pdf->cell(98);
	$pdf->Cell(0,0,"$db[id2] $db[name2]",0,1,'L');
	$pdf->Ln(5);
	$pdf->cell(1);
	$pdf->Cell(0,0,"กีฬา: $db[sp1] จ.$db[chw1]",0,1,'L');	
	$pdf->cell(98);
	$pdf->Cell(0,0,"$sp2",0,1,'L');	

	if ($db[pic3] !='') {	
		$pdf->Image("$bg",0,139,102,140,'','');
		$pdf->Image("../$db[pic3]",8,205,30,35,'','');
		$sp3="กีฬา: $db[sp3] จ.$db[chw3]";
	} else {
		$sp3="";
	}
	if ($db[pic4] !='') {	
		$pdf->Image("$bg",102,139,102,140,'','');
		$pdf->Image("../$db[pic4]",108,205,30,35,'','');
		$sp4="กีฬา: $db[sp4] จ.$db[chw4]";
	} else {
		$sp4="";
	}
	$pdf->Ln(135);
	$pdf->cell(1);
	$pdf->Cell(0,0,"$db[id3] $db[name3]",0,1,'L');
	$pdf->cell(102);
	$pdf->Cell(0,0,"$db[id4] $db[name4]",0,1,'L');
	$pdf->Ln(5);
	$pdf->cell(1);
	$pdf->Cell(0,0,"$sp3",0,1,'L');	
	$pdf->cell(102);
	$pdf->Cell(0,0,"$sp4",0,1,'L');	

	$rw++;
}
$pdf->Output("pdf/MyPDF.pdf","I");
?>