<!--#include file="setup.asp"-->
<!--#include file="hunconn.asp"-->
<% 

name=request("name")
id=request("id") 
%>
<html>
<head>
<title>婚礼列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="forum.css" type="text/css">
</head>

<body bgcolor="#FCC182" text="#000000" leftmargin="0" topmargin="0" class=ct-def3>
&nbsp;&nbsp;<img src="" height=14 width=0><%=name%>
<table width="730" border="0" cellspacing="0" cellpadding="0" class=ct-def2>
<%  
	set rs1=server.createobject("adodb.recordset")

    rs1.open "select * from jie where type="&id&" and datediff('d',year,'"&now()&"')<=long and datediff('d',year,'"&now()&"')>=0",connj,1,1
  	if rs1.bof then 
	rs1.close  %>
	  <tr class=ct-def2> 
    <td bgcolor=D70000 width=100% align=center valign=middle><img src="" height=23 width=0>现在没有人结婚</td>
  </tr>
  <% else %>
  <tr class=ct-def2>
    <td bgcolor=D70000 width=45>&nbsp;</td>
    <td bgcolor=D70000 width=150 align=left><font color=#FFFFFF>新郎</font>&nbsp;<img src=images/img_marry/index_male.gif width=25 height=23></td>
    <td bgcolor=D70000 width=150 align=left><font color=#FFFFFF>新娘</font>&nbsp;<img src=images/img_marry/index_female.gif width=25 height=23></td>
    <td bgcolor=D70000 width=160 align=left><font color=#FFFFFF>开始时间</font>&nbsp;<img src=images/img_marry/index_time.gif width=22 height=23></td>
    <td bgcolor=D70000 width=160 align=left><font color=#FFFFFF>结束时间</font>&nbsp;<img src=images/img_marry/index_time.gif width=22 height=23></td>
    <td bgcolor=D70000 width=50 align=left>&nbsp;</td> 
    <td bgcolor=D70000 width=45>&nbsp;</td>
  </tr>
  <%do while not rs1.eof %>
    <td width=45>&nbsp;</td>
    <td align=left width=150><img src="" height=14 width=0><a href=profile.asp?username=<%=rs1("username")%> target="_blank" title="查看<%=rs1("username")%>的资料"><%=rs1("username")%></a></td>
    <td align=left width=150><a href=profile.asp?username=<%=rs1("thename")%> target="_blank" title="查看<%=rs1("thename")%>的资料"><%=rs1("thename")%></a></td>
    <td align=left width=160><%=rs1("year")%></td>
    <td align=left width=160><%=dateadd("d",rs1("long"),rs1("year"))%></td>
    <td align=left width=50><a href=hundajiudian.asp?id=<%=rs1("ID")%> target=_parent title="参加婚宴">进去瞅瞅</a></td>
    <td width=45 align=left>&nbsp;</td>
  </tr>
  <% rs1.movenext
  loop
  rs1.close
  end if
  %>
</table>
</body>
</html>

