include('db_config.php');
//$sql="select * from $_data,$_act,$_sch
// where kd_code=kp_code and kd_sch=scode and kd_pic <> '' and (g=1 or b=1 or b=1)
// order by rand() limit 0,14";
$sql="select * from $_data,$_act,$_sch
where kd_code=kp_code and kd_sch=scode and kd_pic <> '' and (g=1 or s=1 or b=1)
order by rand() limit 0,14";
$result=mysqli_query($con,$sql);
while ($db=mysqli_fetch_array($result)) {
if ($db[g]==1) {
$med='เหรียญทอง';
} elseif ($db[s]==1) {
$med='เหรียญเงิน';
} elseif ($db[b]==1) {
$med='เหรียญทองแดง';
} else {
$med='';
}
//$cap="$db[kd_std]
รร.$db[sname]
$db[kp_grp] $db[kp_act] รุ่น $db[kp_age] ปี";
$cap="$med
$db[kd_std]
รร.$db[sname]
$db[kp_grp] $db[kp_act] รุ่น $db[kp_age] ปี";
echo "
";
}
mysql_close($con);
?>