<td  align="center"><nobr><%sql="select tb_jxlsb.*,tb_faculty.xsmcheng from tb_jxlsb,tb_faculty where tb_faculty.xsdhao=yxsh order by jsbhao"
rs1.open sql,con,1,1
if not rs1.eof then
   do while not rs1.eof 
%> 

[color=#FF0000]<%=rs1("xsmcheng")%>[/color]

  <%rs1.movenext
  loop
end if
rs1.close
  %></nobr></td>