Question

单位做一个生日提醒网页，当天有多个人过生日，为什么我写的只显示一个人，用的是asp 代码：

<% set rszx=server.createobject("adodb.recordset")
sqlzx ="select * from kyqz_srb where month(birthday)='"&Month(date())&"' and day(shengri)-"&Day(date())&"=0 order by shengri"
rszx.open sqlzx,conn,1,1
renyuan=""
if rszx.bof and rszx.eof then
response.write "<li>无</li>"
renyuan="无 "
else
renyuan=""
do while not rszx.eof
renyuan=rszx("username")
rszx.movenext
loop
end if
rszx.close
response.Write(renyuan)
%>

Answer 1

a=Now()
b=rs("月")
c=rs("日")
if year(a)=b then
if Month(a)=c then response.write rs("姓名")
end if