上面太乱了,看下面的。
[CODE]<p><span class="style11"> <font size="2">下表是查询结果(理论统计数据和实际数据可能有所误差),</font></span><span class="style34 style11"><font size="2">数据较多,<span class="style43">请稍做等待.........</span></font></span></p>
</div></td>
</tr>
</div>
<div id=div1>
<tr>
<td height="141" background="../pictures/0343.jpg">
<table width="800" border="2" align="center" cellpadding="0" cellspacing="0" bordercolor="#009900" style="border-collapse: collapse">
<tr align="center" valign="middle" class="fontsize">
<td width="136" height="25" nowrap><div align="center" class="style42 style46 style54 style42 style55">
<div align="center">编 号</div>
<td width="136" height="25" nowrap><div align="center" class="style42 style46 style54 style42 style55">
<div align="center">公 司 名 称</div>
</div></td>
<td width="58" height="25" nowrap> <div align="center" class="style42 style47 style54 style42">
<div align="center" class="style55">姓 名</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="center">职 务</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="center">E-MAIL</div>
</div></td>
<td width="87" height="25" nowrap> <div align="center" class="style47 style42">
<div align="center">本 人 地 址</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="right">电 话</div>
</div></td>
<td width="72" height="25" nowrap> <div align="center" class="style48 style55">
<div align="center">手 机</div>
</div></td>
<td width="72" height="25" nowrap><div align="center" class="style48 style55">
<div align="center">传 真</div>
</div></td>
<td width="104" height="25" nowrap> <div align="center" class="style55"><strong><span class="style11 fontsize style56"><span class="style54 style55">经 营 范 围</span></span></strong></div></td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql= "select * from mpxxlr where gsmc like '%"&trim(request("gsmc"))&"%'and xm like '%"&trim(request("xm"))&"%' and zw like'%"&trim(request("zw"))&"%'and dz like'%"&trim(request("dz"))&"%' and jyfw like'%"&trim(request("jyfw"))&"%' order by id desc"
rs.open sql,conn,1,1
if rs.recordcount <> 0 then
rs.movefirst
do while not rs.eof
%>
<tr align="center" valign="middle" class="fontsize">
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("ID")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("gsmc")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("xm")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("zw")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("email")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("dz")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("bgdh")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("sj")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("cz")%></div></td>
<td height="25"><div align="center" class="style35 style34 style11"><%=rs("jyfw")%></div></td>
</tr>
<%
rs.movenext
loop
else
%>[/CODE]
我是农家的孩子,我有农家孩子的本色!