birazcik daha aciklasan anlayamadim. Acıksasi hazir bi script buldum bi türlü calistiramadim böle bi hata weriyo eger calisirsa cok süper olcak. Admin paneli falan calismiyor. Database hatasindan büyük ihtimalle... Tam olarak ne yapmam gerek yardimci olursaniz sewinirim arkadaslar




Kod:::::::::::::::::::::::::::::::::::::

<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>