相关新闻程序问题
我在新闻显示页面上底部加了一个相关新闻程序<td> <%Set rs = Server.CreateObject("ADODB.Recordset")
strsql="select top 5 * from news where newstitle like '%"&title&"%' order by newsid desc"
'strsql="select top 5 * from news where content like '%" & about & "%' and newstitle not like '%" & title & "%' order by newsid desc"
'strsql="SELECT top 8 * FROM news where newsclass='10' ORDER BY newsid desc"
rs.Open strsql,conn,1
%> <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center
border=0>
<%do while not rs.eof%> <TBODY>
<TR>
<TD height=2></TD>
</TR>
<TR>
<TD class=table-xia height=24> <img src="images/dian.gif" width="8" height="10"> <a href="../news/inagesnew.asp?id=<%=rs("newsid")%>" target="_blank"><%=mid(rs("newstitle"),1,12)%></a></TD>
</TR><%rs.MoveNext
loop
rs.close %>
</TBODY>
</TABLE>
结果老是提示sql语句有问题?
我看了,表名,字段名都正确