Ïà¹ØÐÂÎųÌÐòÎÊÌâ

isly¡¬

ÎÒÔÚÐÂÎÅÏÔʾҳÃæÉϵײ¿¼ÓÁËÒ»¸öÏà¹ØÐÂÎųÌÐò


<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"
[֪ʶÎÊ´ð¦Ø¦Ø¦Ø.¦ÖiuGoo.§ãom]
'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Óï¾äÓÐÎÊÌâ?

ºÚÏÀ

Ìáʾʲô´íÎó£¿

°®È˺ÃÄÑa

´íÎó '80020009'
/zzcar/news/inagesnew2.asp£¬ÐÐ 143

strsql="select top 5 * from news where newstitle like '%"&title&"%' order by newsid desc"
ÕâÊÇ143ÐÐ

¤´Çã³Ç¨KÁµ

ÄãÔÚÕâ¾ä´úÂëÏÂÃæ¼ÓÉÏresponse.write strsql:response.end
¿´¿´³öʲô

°®Ç麣555

È»ºóÔÚsql²éѯÀïÃæÔËÐÐһϿ´¿´

lala

Äã×öÒ»¸ö¼Ç¼ÊÇ·ñΪ¿ÕµÄÅжϿ´¿´£¿

¦á¨ãÆ®°®¤¢Áµ

ÄãÔÚÕâ¾ä´úÂëÏÂÃæ¼ÓÉÏresponse.write strsql:response.end
¿´¿´³öʲô

¼ÓÁËresponse.write strsql:response.end

»¹ÊÇÌáʾ:
´íÎó '80020009'
/zzcar/news/inagesnew2.asp£¬ÐÐ 143

ºÚ½Ç²ÐÒ¶

ÄDz»ÊÇsqlÓï¾ä´íÎó
ÊÇÓï·¨´íÎó

¨ã½A¿f¤Îo¥¡

¿ÉÄÜtitle±äÁ¿ÀïÃæÓÐ%&gt;³öÏÖÁË

Èð®ÁôÔÚÐĵ×

¿ÉÄÜtitle±äÁ¿ÀïÃæÓÐ%>³öÏÖÁË

ʲôÒâ˼?