商业区引用过来的。。

  Param="WHERE a.title like '%"& keyword & "%' And a.isTop=0 And a.LockTopic=0"

SQLStr="SELECT a.TopicID,a.classid,a.classname,a.title,a.Username,a.Expired,a.Closed,a.DateAndTime,a.LastPostTime,a.LockTopic,a.Reward,a.Hits,a.PostNum,a.CommentNum,a.TopicMode,a.Highlight,a.Broadcast,a.Anonymous,a.IsTop ,b.content FROM KS_AskTopic a inner join ks_askpost1 b on a.topicid=b.topicid " & Param & " ORDER BY a.LastPostTime DESC"


注意每个字段前都加a

再找到下面

Sub EchoTopicItem(sTokenName)
    Select Case sTokenName
      Case "topicid" Echo Topic(0,i)
      Case "classname" Echo Topic(2,i)
      case "content" echo topic(19,i)
      Case "title" Echo KS.Gottopic(Topic(3,i),30)
   Case "username"
    if Topic(17,i)=1 then Echo "匿名" else Echo Topic(4,i)
   Case "time" Echo Topic(7,i)
   Case "postnum" Echo Topic(12,i)
   Case "status" Echo Topic(14,I)
   Case "reward"
    If KS.ChkCLng(Topic(10,I)) > 0 Then
      Echo " <span style=""color:#ff6600;font-weight:bold""><img src='images/ask_xs.gif' align='absmiddle'> " & Topic(10,I) & "</span>"
    End If
    End Select
  End Sub