<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_gg where ggid=2",conn,1,1
newsd1=trim(rs("d1"))
newsd1w=trim(rs("d1w"))
newsd1h=trim(rs("d1h"))
newsd1url=trim(rs("d1url"))
newsd2=trim(rs("d2"))
newsd2w=trim(rs("d2w"))
newsd2h=trim(rs("d2h"))
newsd2url=trim(rs("d2url"))
newsd3=trim(rs("d3"))
newsd3w=trim(rs("d3w"))
newsd3h=trim(rs("d3h"))
newsd3url=trim(rs("d3url"))
newsd4=trim(rs("d4"))
newsd4w=trim(rs("d4w"))
newsd4h=trim(rs("d4h"))
newsd4url=trim(rs("d4url"))
newsd5=trim(rs("d5"))
newsd5w=trim(rs("d5w"))
newsd5h=trim(rs("d5h"))
newsd5url=trim(rs("d5url"))
newsd6=trim(rs("d6"))
newsd6w=trim(rs("d6w"))
newsd6h=trim(rs("d6h"))
newsd6url=trim(rs("d6url"))
newsd7=trim(rs("d7"))
newsd7w=trim(rs("d7w"))
newsd7h=trim(rs("d7h"))
newsd7url=trim(rs("d7url"))
newspf=trim(rs("pf"))
newspfdy=trim(rs("pfdy"))
newspfw=trim(rs("pfw"))
newspfh=trim(rs("pfh"))
newspfurl=trim(rs("pfurl"))
newstc=trim(rs("tc"))
newstcdy=trim(rs("tcdy"))
newstcw=trim(rs("tcw"))
newstch=trim(rs("tch"))
newstcurl=trim(rs("tcurl"))

newsdlz=trim(rs("dlz"))
newsdldy=trim(rs("dldy"))
newsdlzw=trim(rs("dlzw"))
newsdlzh=trim(rs("dlzh"))
newsdlzurl=trim(rs("dlzurl"))
newsdly=trim(rs("dly"))
newsdlyw=trim(rs("dlyw"))
newsdlyh=trim(rs("dlyh"))
newsdlyurl=trim(rs("dlyurl"))

newsx1=trim(rs("x1"))
newsx1w=trim(rs("x1w"))
newsx1h=trim(rs("x1h"))
newsx1url=trim(rs("x1url"))
newsx2=trim(rs("x2"))
newsx2w=trim(rs("x2w"))
newsx2h=trim(rs("x2h"))
newsx2url=trim(rs("x2url"))
newsx3=trim(rs("x3"))
newsx3w=trim(rs("x3w"))
newsx3h=trim(rs("x3h"))
newsx3url=trim(rs("x3url"))
newsx4=trim(rs("x4"))
newsx4w=trim(rs("x4w"))
newsx4h=trim(rs("x4h"))
newsx4url=trim(rs("x4url"))

rs.close
set rs=nothing
if newsx1<>"" then
      newsx1="<a href="&newsx1url&" target=_blank><img src="&newsx1&" width="&newsx1w&" height="&newsx1h&"  border=0></a>"
end if
if newsx2<>"" then
      newsx2="<a href="&newsx2url&" target=_blank><img src="&newsx2&" width="&newsx2w&" height="&newsx2h&"  border=0></a>"
end if
if newsx3<>"" then
      newsx3="<a href="&newsx3url&" target=_blank><img src="&newsx3&" width="&newsx3w&" height="&newsx3h&"  border=0></a>"
end if
if newsx4<>"" then
      newsx4="<a href="&newsx4url&" target=_blank><img src="&newsx4&" width="&newsx4w&" height="&newsx4h&"  border=0></a>"
end if
if newsd1<>"" then
      newsd1="<a href="&newsd1url&" target=_blank><img src="&newsd1&" width="&newsd1w&" height="&newsd1h&"  border=0></a>"
end if
if newsd2<>"" then
      newsd2="<a href="&newsd2url&" target=_blank><img src="&newsd2&" width="&newsd2w&" height="&newsd2h&"  border=0></a>"
end if
if newsd3<>"" then
      newsd3="<a href="&newsd3url&" target=_blank><img src="&newsd3&" width="&newsd3w&" height="&newsd3h&"  border=0></a>"
end if
if newsd4<>"" then
      newsd4="<a href="&newsd4url&" target=_blank><img src="&newsd4&" width="&newsd4w&" height="&newsd4h&"  border=0></a>"
end if
if newsd5<>"" then
      newsd5="<a href="&newsd5url&" target=_blank><img src="&newsd5&" width="&newsd5w&" height="&newsd5h&"  border=0></a>"
end if
if newsd6<>"" then
      newsd6="<a href="&newsd6url&" target=_blank><img src="&newsd6&" width="&newsd6w&" height="&newsd6h&"  border=1 style=""border-color:#000000""></a>"
end if
if newsd7<>"" then
      newsd7="<a href="&newsd7url&" target=_blank><img src="&newsd7&" width="&newsd7w&" height="&newsd7h&"  border=0></a>"
end if
if newspf<>"" then
      newspf="<a href="&newspfurl&" target=_blank><img src="&newspf&" width="&newspfw&" height="&newspfh&"  border=0></a>"
end if
if newsdlz<>"" then
      newsdlz="<a onClick=closeBanner(); href="&newsdlzurl&" target=_blank><img src="&newsdlz&" width="&newsdlzw&" height="&newsdlzh&"  border=0></a>"
end if
if newsdly<>"" then
      newsdly="<a onClick=closeBanner(); href="&newsdlyurl&" target=_blank><img src="&newsdly&" width="&newsdlyw&" height="&newsdlyh&"  border=0></a>"
end if

%>