´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • Ãʺ¸ / 2001-10-20 / ¿ÀÈÄ 6:19:32 / 211.225.216.167
    Á¶È¸¼ö : 135
    [Áú¹®] µµ¿Í ÁÖ¼¼¿ä.
    ¾Æ·§±Û 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>"

    %>
    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :