<table border="0" width="170" height="21" cellspacing="1" cellpadding="0" style="cursor:default;">
 <% 
 set sonOku = server.createobject("adodb.recordset")
 sonOku_S = ("SELECT nick,sum(kazanc) as kazanc1 from  kupon_list WHERE ay LIKE '"&month(date())&"' GROUP BY nick ORDER BY sum(kazanc) DESC;")
 sonOku.open sonOku_S,baglanti,1,3
 %> 
 
 <tr bgcolor="#efefef">
  <td width="80" style="border-bottom: solid #cdcdcd 1px;" ><b>Nick</b></td>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;"><img src="images/won.gif"></td>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;"><img src="images/lost.gif"></td>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;"><b>Toplam</b></td>
 </tr>
 <%
 while not sonOku.eof 
 %>
 <%
 set sWin = server.createobject("adodb.recordset")
 sWin_S = ("SELECT * from  kupon_list WHERE nick LIKE '"&sonOku("nick")&"' and sonuc LIKE '1' and ay LIKE '"&month(date)&"' ")
 sWin.open sWin_S,baglanti,1,3
 
 set sLost = server.createobject("adodb.recordset")
 sLost_S = ("SELECT * from  kupon_list WHERE nick LIKE '"&sonOku("nick")&"' and sonuc LIKE '0' and ay LIKE '"&month(date)&"' ")
 sLost.open sLost_S,baglanti,1,3
 %>
 <tr bgcolor="#F5F5F7" <!--#include file = "orta_menu_move.asp"-->>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;" ><img src="images/next.gif"> <% =sonOku("nick") %></td>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;"><% =sWin.recordcount %></td>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;"><% =sLost.recordcount %></td>
  <td width="80" style="border-bottom: solid #cdcdcd 1px;">
  <% =sonOku("kazanc1") %>
  Ytl</td>
 <%
 sonOku.movenext
 wEnd
 %>
 </tr>
 
</table>