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

query("select nameA,id,teachA from thannam_champion_teamm where match1=$match order by id asc "); $nmm12 = mysql_num_rows($sql12); while($res = $db->rows($sql12)){ ?>
TEAM NAME [GOLD] TOTAL
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; } #=========================== } ?>