程序代码:
<%
sql="select * from yezhu where month(shui)<="&month(date())&" and day(shui)<="&day(date()+5)&" and month(wenhou)<"&month(date())
if nowxiaoqu="" then
sql=sql&" order by id"
else
sql=sql&" and xiaoqu="&nowxiaoqu&" order by id"
end if
set rs_yezhu=conn.execute(sql)