关于ASP开奖日期的网站建设的运用问题

 

 

 <% 

s=year(date())&"-"&month(date())&"-"&day(date())

s1=year(date())&"-"&month(date())&"-"&day(date()-1)

 

a=now()

 

b1=cdate(date()&" 21:35:00")

a1=cdate(now())

 

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

 

if b1<a1 then

 

exec="select   * from [kj]  where riqi='"&s&"'  order by id desc  " 'top 5代表每栏目显示5条新闻

 

else

 

exec="select   * from [kj]  where riqi='"&s1&"'  order by id desc  " 'top 5代表每栏目显示5条新闻

 

 

end if

 

news.open exec,conn,1,1 

if news.eof or news.bof then

response.Write ("暂无开奖信息请稍后 !")

else

 

 

%>

 

<%

 

b1=cdate(news("riqi")+" "+news("yis")+":"+news("yif")+":"+news("yim"))

b2=cdate(news("riqi")+" "+news("ers")+":"+news("erf")+":"+news("erm"))

b3=cdate(news("riqi")+" "+news("sans")+":"+news("sanf")+":"+news("sanm"))

b4=cdate(news("riqi")+" "+news("sis")+":"+news("sif")+":"+news("sim"))

b5=cdate(news("riqi")+" "+news("wus")+":"+news("wuf")+":"+news("wum"))

b6=cdate(news("riqi")+" "+news("lius")+":"+news("liuf")+":"+news("lium"))

b7=cdate(news("riqi")+" "+news("tes")+":"+news("tef")+":"+news("tem"))

 

c1= datediff("s",a,b1)

c2= datediff("s",a,b2)

c3= datediff("s",a,b3)

c4= datediff("s",a,b4)

c5= datediff("s",a,b5)

c6= datediff("s",a,b6)

c7= datediff("s",a,b7)

 

%> 

 

 

 

 

<div class="lotteryIssue">第 <span><%=news("title")%></span> 期</div>

</div>

 

 

<div class="num">

 

<span>

<span class="ball">

<% if c1<0  then%><span class="balls   <% if news("yih")="01" or news("yih")="02"  or news("yih")="07"  or news("yih")="08"  or news("yih")="12"  or news("yih")="13"  or news("yih")="18"  or news("yih")="19"  or news("yih")="23"  or news("yih")="24"  or news("yih")="29"  or news("yih")="30"  or news("yih")="34"  or news("yih")="35"  or news("yih")="40"  or news("yih")="45"  or news("yih")="46"  then %>red<%end if%><% if news("yih")="03" or news("yih")="04"  or news("yih")="09"  or news("yih")="10"  or news("yih")="14"  or news("yih")="15"  or news("yih")="20"  or news("yih")="25"  or news("yih")="26"  or news("yih")="31"  or news("yih")="36"  or news("yih")="37"  or news("yih")="41"  or news("yih")="42"  or news("yih")="47"  or news("yih")="48"  then %>blue<%end if%><% if news("yih")="05"  or news("yih")="06"  or news("yih")="11"   or news("yih")="16"  or news("yih")="17"  or news("yih")="21"  or news("yih")="22"  or news("yih")="27"  or news("yih")="28"   or news("yih")="32"  or news("yih")="33"   or news("yih")="38"  or news("yih")="39"  or news("yih")="43"  or news("yih")="44"  or news("yih")="49" then %>green<%end if%>"><%=news("yih")%></span><span class="shengxiao"><%=news("yix")%></span><%else%>...<%end if%>

</span>

 

 

 

 

 

</div>

 

 

</div>

  

 

 

<%

 

 

news.close

set news=nothing

end if

%>