|
|
|
|
俵ÀÌ / 2001-10-21 / ¿ÀÈÄ 8:21:18 / 203.255.3.190
Á¶È¸¼ö : 134
|
[Áú¹®] µµ¿Í ÁÖ¼¼¿ä. |
> ¾Æ·§±Û 3625 ³²°å¾ú´Âµ¥ µµ¿Í ÁÖ¼¼¿ä.
>
> db(¾×¼¼½º)ÀÇ scores Å×ÀÌºí¿¡¼ Á¡¼öÇʵ带 ºÒ·¯¿Í
> Á¡¼ö°¡ ³ôÀº ¼ø¼´ë·Î ¹øÈ£¸¦ ¸Å°Ü ¼øÀ§¸¦ Á¤Çߴµ¥
> ±×¸¸ µ¿Á¡ÀÚ Ã³¸®°¡ µÇÁö°¡ ¾Ê³×¿ä.
>
> Á¡¼ö°¡ °°À»°æ¿ì ¼øÀ§¸¦ °°°Ô ÇÏ°í ±× ´ÙÀ½ Á¡¼öÀÚ¿¡°Ô´Â
> µ¿Á¡ÀÚ ¸¹Å ¼øÀ§°¡ µÚ·Î ¹Ð¸®°Ô ÇÏ°í ½ÍÀºµ¥ ¾î¶»°Ô
> ÇؾßÇÒÁö ¸ð¸£°Ú¾î¿ä.
>
> ¿¹)
> Çйø: A01, A02, A03, A04, ...
> Á¡¼ö: 90,80,80,70, ...
> ¼øÀ§: 1µî,2µî,2µî,4µî, ...
>
> <%
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "ASPCBT"
> SQL3 = "SELECT * FROM scores ORDER BY Á¡¼ö DESC"
> Set RS = Conn.Execute (SQL3)
>
> rank = 0
> %>
> <table width=200 border=1>
> <td align=center width=50 BGCOLOR=#800000>
> <FONT COLOR=#ffffff SIZE=2><b>µî ¼ö</b></font></td>
> <td align=center width=100 BGCOLOR=#800000>
> <FONT COLOR=#ffffff SIZE=2><b>ÀÌ ¸§</b></font>
> <td align=center width=50 BGCOLOR=#800000>
> <FONT COLOR=#ffffff SIZE=2><b>Á¡ ¼ö</b></font>
> </td></tr>
>
> <%
> do until rs.eof
> response.write "<tr>"
> rank = rank + 1
>
> response.write "<td align=center>" & rank & "</td>"
> response.write "<td align=center>" & rs("À̸§") & "</td>"
> response.write "<td align=center>" & rs("Á¡¼ö") & "</td>"
>
> rs.movenext
>
> response.write "</tr>"
> loop
> response.write "</table>"
>
> %>
-----------------------------------------------------------
Á¡¼ö¸¦ ºñ±³Çؼ ÀÌÀü Á¡¼ö¿Í ´Ù¸¦¶§¸¸ µî¼ö¸¦ ¿Ã¸®¸é µÇ°ÚÁÒ...
previousScore = -1
do until rs.eof
response.write "<tr>"
nowScore=CInt(rs("Á¡¼ö"))
if previousScore <> nowScore then
nowRank = rank + 1
end if
rank = rank + 1
response.write "<td align=center>" & nowRank & "</td>"
response.write "<td align=center>" & rs("À̸§") & "</td>"
response.write "<td align=center>" & rs("Á¡¼ö") & "</td>"
previousScore = nowScore
rs.movenext
response.write "</tr>"
loop
±×·³....
|
|
|
|