@session_start(); define("PATH_FILE",true); require_once("applications/functions.php"); require_once("functionsW2.php"); global $config, $prefix, $db; $matchrow = $db->rows($db->query("select * from thannam_match where id=$_GET[match]")); #===================Random Auto คู่สาย if($matchrow[autorandoma]==0){ $orderby= " order by rand() "; }else{ $orderby= " order by num"; } #================================== #=======================DATA if($statusA=='FIG'){ $dataA = ' thannam_champion_mann '; $statusB = ' FIGHTING '; $fildee = 'fig'; }elseif($statusA=='NEW'){ $dataA = ' thannam_champion_mannb '; $statusB = ' NEWAZA '; $fildee = 'newaza'; }elseif($statusA=='NNG'){ $dataA = ' thannam_champion_mannNG '; $statusB = ' NEWAZA NO GI'; $fildee = 'nng'; }elseif($statusA=='FCT'){ $dataA = ' thannam_champion_mannFC '; $statusB = ' FULL CONTACT'; $fildee = 'fullcontact'; } #=======================DATA END ?>
ALL TEAM ALL SCORE FIGHTING NEWAZA NEWAZA NOGI FULL CONTACT
TEAM | NAME [GOLD] | TOTAL |
---|---|---|
$rrs = $db->query("select * from $dataA where idteam=$res[id] and final='ทอง' ");
$nnn = mysql_num_rows($rrs);
//echo ' '; $i=0; while($res2 = $db->rows($rrs)){ #===========================ในรุ่นมี กี่คน $manaa = $db->query("select * from $dataA where idgroup='$res2[idgroup]'"); $nnna = mysql_num_rows($manaa); #=========================== #===========================เอาคนที่ได้เหรียญทองโชว์ if($nnna>0){ $manaa2 = $db->rows($db->query("select * from $dataA where idgroup='$res2[idgroup]' and final='ทอง'")); echo $nnna; echo ' - '; echo $manaa2[nameA]; echo ' '; $i+=1; } #=========================== } ?> |
if($i!=0){ echo $i; } ?> |