Código PHP:
<table width="100%" cellpadding="2" cellspacing="2"> <tbody> <tr> <table class="mvcore-table" cellpadding="0" cellspacing="0"> <td><b>Nome</b></td> <td><b>Ganhou</b></td> <td><b>Lose</b></td> </tr> <?PHP
$guild_query = mssql_query("SELECT top 10 Name from Character order by WinDuels desc"); for($i=0;$i < mssql_num_rows($guild_query);++$i) { $row = mssql_fetch_row($guild_query);
$sql_char = mssql_query("Select LoseDuels,WinDuels from Character where Name='$row[0]'"); $show = mssql_fetch_row($sql_char);
$sql_ce = mssql_query("SELECT count(*) FROM LoseDuels WHERE name = '$row[0]'"); $mcount = mssql_result($sql_ce, 0, 0);
if($show[0] == '') { $DropgScore = '0'; } else { $DropgScore = $show[0]; };
$rank = $i+1;
$tr_color_2 = "even2"; $tr_color_1 = "even"; $tr_color = ($rank % 2) ? $tr_color_1 : $tr_color_2; echo "
<tr style='border-collapse: collapse; border-spacing: 0px;'> <td><a href='#'>$row[0]</a></td> <td><a href='#'>$show[1]</a></td> <td>$DropgScore</td> </tr> "; } ?></table>
Como Usar: