28,390
社区成员
发帖
与我相关
我的任务
分享关于产品显示问题。急，新人！
小弟初学ASP，不知道怎么解决动态显示产品的问题。问题是这样的：在红色部分显示从数据库里面获取的产品信息，包括图片、产品名称、价格三个字段。该如何写呢？
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--#include file="conn.asp" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>杭州临安军刚电脑科技有限公司</title>
<!--[if IE]>
<style type="text/css">
/* 请将所有版本的 IE 的 css 修复放在这个条件注释中 */
.thrColLiqHdr #sidebar2, .thrColLiqHdr #sidebar1 { padding-top: 30px; }
.thrColLiqHdr #mainContent { zoom: 1; padding-top: 15px; }
/* 上面的专用 zoom 属性为 IE 提供避免错误所需的 hasLayout */
</style>
<![endif]-->
<link href="main2.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body,td,th {
font-family: 宋体;
font-size: 10pt;
}
.STYLE16 {font-size: 10pt; color: #000000;}
-->
</style></head>
<body class="thrColLiqHdr">
<%
dim rs,sql
set rs = server.CreateObject("adodb.recordset")
sql="select * from products order by p_id,p_bh"
rs.open sql,conn,1,1
if not (rs.bof or rs.eof) then
p_id = Rs("p_id")
p_bh = Rs("p_bh")
p_name = Rs("p_name")
p_bcid = Rs("p_bcid")
p_scid = Rs("p_scid")
p_bid = Rs("p_bid")
p_type = Rs("p_type")
p_img = Rs("p_img")
p_sn = Rs("p_sn")
p_sdw = Rs("p_sdw")
p_bdw = Rs("p_bdw")
p_hs = Rs("p_hs")
p_info = Rs("p_info")
p_pyjm = Rs("p_pyjm")
price1 = formatnumber(Rs("price1"))
price2 = Rs("price2")
isweb = Rs("isweb")
p_uid = Rs("p_uid")
p_addtime = Rs("p_addtime")
p_zt = Rs("p_zt")
end if
%>
<div id="container">
<div id="header">
<ul style="list-style-type:none; padding:0; margin:0;">
<li style="display:inline;"><img src="images/logo-4.png" /></li>
<li style="display:inline; width:100px;"> </li>
<li style="display:inline; padding:5px 5px;"><img src="images/logo-tp1.png" hspace="2" vspace="10" border="0" /><a href="index.html"><img src="images/home.png" vspace="10" border="0" /></a></li>
<li style="display:inline; padding:5px 5px;"><img src="images/logo-tp2.png" vspace="10" border="0" /><a href="products.html"><img src="images/computer.png" vspace="10" border="0" /></a></li>
<li style="display:inline; padding:5px 5px;"><img src="images/logo-tp3.png" vspace="8" border="0" /><a href="products-1.html"><img src="images/sm-sj.png" vspace="10" border="0" /></a></li>
<li style="display:inline; padding:5px 5px;"><img src="images/logo-tp4.png" vspace="10" border="0" /><a href="products-2.html"><img src="images/office.png" vspace="10" border="0" /></a></li>
<li style="display:inline; padding:5px 5px;"><img src="images/logo-tp5.png" vspace="10" border="0" /><a href="products-3.html"><img src="images/wljk.png" vspace="10" border="0" /></a></li>
<li style="display:inline; padding:0 10px ;"><img src="images/logo-tp6.jpg" /> 加入收藏</li>
</ul>
<img src="images/tp.jpg" width="935" height="249" align="middle" />
<!-- end #header --></div>
<div id="sidebar1">
<ul style="list-style-type:none; margin:0; padding:10px 0;">
<li class="leftbk_t"></li>
<li class="leftbk_c">
<ul class="leftmenu">
<li><img src="images/tp-07.jpg" width="170" height="31" /></li>
</ul>
<ul class="left">
<li class="leftli"><a href="#" class="nr">2000~3000</a></li>
<li class="leftli"><a href="#" class="nr">3000~4000</a></li>
<li class="leftli"><a href="#" class="nr">4000~5000</a></li>
<li class="leftli"><a href="#" class="nr">6000~7000</a></li>
<li class="leftli"><a href="#" class="nr">7000~10000</a></li>
</ul>
</li>
<li class="leftbk_b"></li>
</ul>
<ul style="list-style-type:none; margin:0; padding:1px 0">
<li class="leftbk_t"></li>
<li class="leftbk_c">
<ul class="leftmenu">
<li ><img src="images/tp-08.jpg" /></li>
</ul>
<ul class="left">
<li class="leftli"><a href="#" class="nr">联想</a></li>
<li class="leftli"><a href="#" class="nr">惠普</a></li>
<li class="leftli"><a href="#" class="nr">戴尔</a></li>
<li class="leftli"><a href="#" class="nr">华硕</a></li>
</ul>
</li>
<li class="leftbk_b"></li>
</ul>
<ul style="list-style-type:none; margin:0; padding:1px 0">
<li class="leftbk_t"></li>
<li class="leftbk_c">
<ul class="leftmenu">
<li ><img src="images/tp-09.jpg" /></li>
</ul>
<ul class="left">
<li class="leftli"><a href="#" class="nr">硬盘</a></li>
<li class="leftli"><a href="#" class="nr">内存卡</a></li>
<li class="leftli"><a href="#" class="nr">显卡</a></li>
<li class="leftli"><a href="#" class="nr">硬盘</a></li>
</ul>
</li>
<li class="leftbk_b"></li>
</ul>
<ul style="list-style-type:none; margin:0; padding:1px 0">
<li class="leftbk_t"></li>
<li class="leftbk_c">
2332122<br />
2222222<br />
222222<br />
222222<br />
<br />
<br />
</li>
<li class="leftbk_b"></li>
</ul>
<!-- end #sidebar1 --></div>
<div id="mainContent">
<img src="images/tp-012.png" width="97" height="21" align="top" />
<ul style="margin:0 0 0 550px; display:inline; ">更多</ul>
<div id="middle">
<div id="tp">
<div id="pic"><a href="#"><img src="<%=p_img%>" border="0" /></a></div>
<div id="bt"><a href="#" class="nr"><%=p_name%></a></div>
<div id="money"><span class="STYLE16">￥<%=price1%></span><br />
</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-28.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr"><%=p_name%></a></div>
<div id="money">￥<%=price1%></div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-29.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-30.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-27.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345<br /></div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-28.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345<br />
<br />
<br />
</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-29.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-30.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-28.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-29.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
</div>
</div>
<div id="mainContent2">
<br />
<img src="images/tp-010.png" width="103" height="23" align="top" />
<ul style="margin:0 0 0 530px; display:inline;">更多</ul>
<div id="middle">
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-27.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345<br />
<br />
<br />
</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-28.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-29.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-30.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-27.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345<br /></div>
</div>
</div>
</div>
</div>
<b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b></b>
</div>
<!-- end #footer -->
<!-- end #container --></div>
</body>
</html>
...全文
请发表友善的回复…
发表回复
凡夫与俗子 2009-06-19
- 打赏
- 举报
就是显示这一部分。。
<div id="tp">
<div id="pic"><a href="#"><img src="<%=p_img%>" border="0" /></a></div>
<div id="bt"><a href="#" class="nr"><%=p_name%></a></div>
<div id="money"><span class="STYLE16">￥<%=price1%></span><br />
</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-28.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr"><%=p_name%></a></div>
<div id="money">￥<%=price1%></div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-29.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div>
</div>
<div id="tp">
<div id="pic"><a href="#"><img src="images/tp-30.png" border="0" /></a></div>
<div id="bt"><a href="#" class="nr">联想联想联想联想</a></div>
<div id="money">￥12345</div
