<!--#include file="conn.asp" -->

<%
exec="select * from user order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<link href="../css/aindex.css" rel="stylesheet" type="text/css" />
<link href="../css/index.css" rel="stylesheet" type="text/css" />
<link href="../css/alink.css" rel="stylesheet" type="text/css" />
<table width="100%" align="right" cellpadding="5" cellspacing="1" class="bx"> 
     <tr>
       <td colspan="9" bgcolor="#34A6DC" class="bg">會員列表</td>
     </tr>
     <tr>
       <td colspan="9" bgcolor="#FFFFFF">
         <!--#include file="u_so.asp" -->
       </td>
     </tr>
     <tr>
       <td colspan="9" class="bg4">
         <!--#include file="pg.asp" -->
       </td>
     </tr>
     <tr>
       <td width="4%" class="bg">編號</td>
	   <td width="12%" class="bg">照片</td>
	   <td width="43%" class="bg">用戶</td>
	   <td width="20%" class="bg">操作</td>
       <td width="21%" class="bg">√為已入學/時間</td>
     </tr>
<% for i=1 to rs.pagesize %>	 
<% if rs.eof then
   exit for
   end if
%>
     <tr bgColor=#FFFFFF onMouseOver="javascript:this.bgColor='#E6F7FB';"onMouseOut="javascript:this.bgColor='#FFFFFF';" >
       <td><%=i%></td>
	   <td><a href="../up/<%=rs("img")%>">
	<%if rs("img")<>"" then%>
	<img src="../up/<%=rs("img")%>" width="100" height="140" border="0">
	<%else%>
	<img src="../img/nopic.gif" width="120" height="150" border="0" />
	<%end if%>
	   </a></td>
	   <td>用戶:<a href="u_u.asp?id=<%=rs("id")%>"><%=rs("uname")%></a><br>姓名:<a href="u_u.asp?id=<%=rs("id")%>"><%=rs("un")%></a><font color=#009900"><strong>
	     <% if rs("rx")="是" then response.write"√" %>
	   </strong></font><%=rs("xb")%><br />
	   生日:<%=rs("sr")%><br />
	   電話:<%=rs("tel")%><br />
	   QQ:<a href="href=http://wpa.qq.com/msgrd?V=1&amp;Uin=314191031&amp;Site=互動服務&amp;Menu=yes"target="blank" ><%=rs("qq")%></a></td>
	   <td>
	   <a href="u_check.asp?id=<%=rs("id")%>">修改</a> 
	   <a href="u_del.asp?id=<%=rs("id")%>">刪除</a>
　<a href="u_del.asp?id=<%=rs("id")%>">       
<%
	    if rs("rx")="是" then 
		  Response.Write "<a href=ubm.asp?rx=否&id="&rs("id")&">取消入學</a>"
        else
	      Response.Write "<a href=ubm.asp?rx=是&rd="&date&"&id="&rs("id")&">確認入學 ●</a>" 
		end if		
	   %>
      </a> </td>
       <td><a href="u_del.asp?id=<%=rs("id")%>">
         <%
	    if rs("rx")="是" then 
		  Response.Write "<a href=ubm.asp?rx=否&id="&rs("id")&">√</a>　　入學時間:"
        else
	      Response.Write "<a href=ubm.asp?rx=是&rd="&date&"&id="&rs("id")&">●</a>" 
		end if		
	   %>
       </a><%=rs("rd")%></td>
     </tr>

   
<%
rs.movenext
next
%>  
</table>