Ordenacao depois de ler o banco de dados e fazer uma soma
Tenho esse codigo e gostaria que a ordenacao seja feita pela variavel total que so tem os valores inseridos depois de ler o banco
alguem pode me ajudar é muito urgente
Muito obrigado
ai vai o codigo com a variavel total em negrito
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="[http://www.w3.org/1999/xhtml">](http://www.w3.org/1999/xhtml)
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css"><!--
.style2 {color: #FFFFFF; font-weight: bold; }
-->
</style>
</head>
<body><% DIM CONEXAO,TABELA
SET CONEXAO = SERVER.CREATEOBJECT("ADODB.CONNECTION")
CONEXAO.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("DBASE/USERMAN.MDB")
SET TABELA = CONEXAO.EXECUTE ("SELECT * FROM points")
dim primeiro, segundo, terceiro, quarto, quinto, sexto, setimo, oitavo, nono, decimo, spent, [b]total[/b]
dim startup, lugar, jogadas, referral, newlocation, totalchips
primeiro = 0
segundo = 0
terceiro = 0
quarto = 0
quinto = 0
sexto = 0
setimo = 0
oitavo = 0
nono = 0
decimo = 0
[b]total = 0[/b]
spent = 0
startup = 0
lugar = 0
jogadas = 0
referral = 0
newlocation = 0
totalchips = 0%>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="37" height="68" bgcolor="#003300"><div align="center" class="style2">Rank</div></td>
<td width="84" bgcolor="#003300"><div align="center" class="style2">Player Name</div></td>
<td width="55" bgcolor="#003300"><div align="center" class="style2">Points</div></td>
<td width="66" bgcolor="#003300"><div align="center" class="style2">Chips for Finals</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">1st</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">2nd</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">3rd</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">4th</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">5th</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">6th</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">7th</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">8th</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">9th</div></td>
<td width="40" bgcolor="#003300"><div align="center" class="style2">10th</div></td>
<td width="59" bgcolor="#003300"><div align="center" class="style2">Nightly Spent</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">Nightly Spending Bonus 1=2</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">Start Up Chips</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">Referrals #</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">Referrals bunus Referrals X 50</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">New Location #</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">New Location Referrals X 2500</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">#</div></td>
<td width="64" bgcolor="#003300"><div align="center" class="style2">Nights Attended Bonus</div></td>
</tr>
<%Do While not Tabela.EOF %>
<tr>
<td height="30"><div align="center"></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("player")%></div></td>
<%
primeiro = Tabela.Fields("1")*250
segundo = Tabela.Fields("2")*125
terceiro = Tabela.Fields("3")*100
quarto = Tabela.Fields("4")*80
quinto = Tabela.Fields("5")*60
sexto = Tabela.Fields("6")*40
setimo = Tabela.Fields("7")*30
oitavo = Tabela.Fields("8")*20
nono = Tabela.Fields("9")*10
decimo = Tabela.Fields("10")*5
spent = Tabela.Fields("spent")*2
[b]total = primeiro+segundo+terceiro+quarto+quinto+sexto+setimo+oitavo+nono+decimo+spent[/b]
startup = Tabela.Fields("start up")
lugar = Tabela.Fields("1")*100
if Tabela.Fields("attend") <= 20 then
jogadas = 1000
else
jogadas = 2000
end if
referral = Tabela.Fields("referralnumber")*50
newlocation = Tabela.Fields("locationnumber")*2500
totalchips = startup+lugar+jogadas+referral+newlocation
%>
<td height="30"><div align="center"><%= total%></div></td>
<td height="30"><div align="center"><%= totalchips%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("1")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("2")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("3")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("4")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("5")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("6")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("7")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("8")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("9")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("10")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("spent")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("spent")*2 %></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("start up")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("referralnumber")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("referralnumber")*50%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("locationnumber")%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("locationnumber")*2500%></div></td>
<td height="30"><div align="center"><%= Tabela.Fields("attend")%></div></td>
<td height="30"><div align="center">
<% if Tabela.Fields("attend") <= 20 then
response.write "1000"
else
response.write "2000"
end if %>
</div></td>
</tr></table>
</body>
</html>Discussão (4)
Carregando comentários...