´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • Ãʺ¾´Ï´Ù. / 2003-06-18 / ¿ÀÈÄ 8:05:01 / 211.201.224.97
    Á¶È¸¼ö : 189
    [Áú¹®] Ʋ¸°ºÎºÐ ¼öÁ¤ Á» ºÎŹµå¸±²²¿ä..
    asp¸¦ °øºÎÇÏ°í ÀÖ´Â Ãʺ¸ÀÔ´Ï´Ù...
    È¥ÀÚÀÇ ÈûÀ¸·Î °Ô½ÃÆÇ ¸¸µé±â¸¦ ÇÏ°í ÀÖ½À´Ï´Ù,.,
    ±Ùµ¥¿ä..list ÆäÀÌÁö¿¡¼­...¸îÁÙ¾¿ º¸±â Çຸ±â¶ó°í Çϳª¿ä...Ŭ¸¯Çϸé...10°³ ¶Ç´Â 15,20°³¾¿ º¸ÀÌ´Â°Í ¸»ÀÔ´Ï´Ù...È¥ÀÚ ±¸ÇöÇغ¼·Á±¸ Çߴµ¥..
    Àß ¾È‰Ï´Ï´Ù...
    ¾Æ·¡¿¡ ¼Ò½º¸¦ ºÙÀÌ´Ï...¾Æ½Ã´Â ºÐÀº ¾îµð°¡ À߸øµÆ´ÂÁö Áöµµ Á» ºÎŹµå¸³´Ï´Ù...Á¦¹ß¿ä..¤Ð¤Ð
    list.asp Àüü ¼Ò½º ÀÔ´Ï´Ù..

    <%
    if request("page")="" then
    page=1
    else
    page=request("page")
    end if

    set db=server.createobject("adodb.connection")
    db.open "mysitedb","sa","asp"

    sql="select * from MyBoard ORDER BY m_num DESC"

    set rs=server.createobject("adodb.recordset")

    'ÆäÀÌÁö Å©±â°ª¾ò±â..
    select2=request(select2)

    if(Cint(select2)>0) then
    rs.pagesize=select2 'ÆäÀÌÁö»çÀÌÁî ÁöÁ¤. ¹Ýµå½Ã ·¹ÄÚµå¼Â¿ÀÇÂÀü¿¡ ÁöÁ¤ÇؾßÇÔ..
    else
    rs.pagesize=5
    end if
    rs.open sql,db,1
    %>


    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title>Untitled Document</title>
    <meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
    <script language="javascript">
    function selFunc()
    {
    location.reload();
    }
    </script>

    </head>

    <body>
    <%if rs.BOF or rs.EOF then%>
    <center>¾Æ¹«µ¥ÀÌŸ ¾ø½¿´ç</center>
    <%
    else
    totalpage=rs.pagecount 'ÃÑÆäÀÌÁö¼ö¸¦ totalº¯¼ö¿¡ ³Ñ..
    rs.absolutepage=page 'ÁöÁ¤µÈ ÆäÀÌÁö·Î ·¹ÄÚµåÀÇ ÇöÀçÀÇ À§Ä¡¸¦ À̵¿
    %>
    <table width="75%" border="0" align="center">
    <tr>
    <td><table width="588" border="0" align="center">
    <tr>
    <td><div align="center"><font color="#000066" size="6"><strong>My List</strong></font></div></td>
    </tr>
    </table>
    <table width="588" border="0" align="center">

    <tr>

    <td width="185" height="58"><p><a href="write.htm"><img src="bullet2-02161.gif" width="15" height="16" border=0><font size="2">write</font></a></p>
    </td>
    <td width="393"> <div align="right"><font size="2">Çà º¸±â

    <select name="select2" onchange="selFunc();">
    <option value="5" selected> 5°³</option>
    <option value="10">10°³</option>
    <option value="15">15°³</option>
    <option value="20">20°³</option>
    <option value="25">25°³</option>
    <option value="30">30°³</option>
    </select>
    </font> </div></td>
    </tr>

    </table>
    <table width="588" border="0" align="center">
    <tr>
    <td width="11%" height="30" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>¹øÈ£</strong></font></div></td>
    <td width="18%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>±Û¾´ÀÌ</strong></font></div></td>
    <td width="19%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>³¯Â¥</strong></font></div></td>
    <td width="41%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>Á¦¸ñ</strong></font></div></td>
    <td width="11%" bgcolor="#000066"><div align="center"><font color="#FFFFFF"><strong>Á¶È¸¼ö</strong></font></div></td>
    </tr>
    <%
    i=1
    do until rs.EOF or i>rs.pagesize
    %>
    <tr>
    <td bgcolor="#FFFFCC"><div align="center"><%=rs("m_num")%></div></td>
    <td bgcolor="#FFFFCC"><div align="center"><a href="mailto:<%=rs("m_email")%>"><%=rs("m_name")%></a></div></td>
    <td bgcolor="#FFFFCC"><div align="center"><%=left(rs("m_writeday"),10)%></div></td>
    <td bgcolor="#FFFFCC"><div align="center"><a href="read.asp?idx=<%=rs("m_board_idx")%>"><%=rs("m_title")%></a></div></td>
    <td bgcolor="#FFFFCC"><div align="center"><%=rs("m_readnum")%></div></td>
    </tr>
    <%
    rs.MoveNext
    i=i+1
    loop
    %>
    <%end if%>
    </table>
    <hr align="center" width="588"> <p> </p>
    <center><font size=2>
    <%if page <> 1 then%>
    <<a href="list.asp?page=<%=page-1%>">ÀÌÀüÆäÀÌÁö</a>>
    <%end if%>
    <%if cint(page) <> cint(totalpage) then%>
    <<a href="list.asp?page=<%=page+1%>">´ÙÀ½ÆäÀÌÁö</a>>
    <%end if%>
                 
    <%=page%>page/<%=totalpage%>pages
    </font></center>
    </td>
    </tr>
    </table>
    <p> </p>
    </body>
    </html>
    <%
    rs.close
    db.close
    set rs=nothing
    set db=nothing
    %>

    ºÎŹµå¸³´Ï´Ù..¾Ë·ÁÁÖ¼¼¿ä
    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :