數據庫：
ID:貼子的id號，自動編號
OrderID:排序基數，以下詳細描述
.
.
.
數據：
主體貼：第一個主題貼OrderID為aaaaaaz（其中的6個a是為了這個版面上最多可以有999999*26條主題貼，當然，您可以根據自己的需要更改。z作為排序的識別碼，永遠無變化。），第二個主題貼為aaaaabz，就是說，每增加一個主題貼，OrderID上漲一個字母。
子帖：第一個子貼在父貼的OrderID的基礎上，在z前面增加一位a，第二個子貼在父貼的OrderID的基礎上，在z的前面增加一位b，以此類推。也就是說，同一層的貼子，每增加一個，OrderID上漲一個字母，同上，z永遠不變。
可以看出，同一層的貼子OderID的位數相同；而回復同一主題的貼子，OrderID的前n位相同；這樣，貼子所在層數可以由OrderID的位數得出；而貼子的總體排序by OrderID desc;而上一主題貼就是字符減一，下一主題貼就是字符加一咯！
發言：add_massege.asp
------------部分，未經優化整理------------
<body bgcolor="#C8C8E6">
<script language="VBScript">
Sub GoBack()
form1.btn1.value="返回"
history.go(-1)
end sub
</Script>
<%
name1=Session("Uname")
If name1="" Then
Response.Write"<font size=3 color=blue><center>"
Response.Write"<br>"
Response.Write"<br>"
Response.Write"只有會員才能使用此項功能，請您注冊或登錄！ <p>"
Response.Write"<a href=main1.htm>回上頁</a>"
Response.End
End If
psw1=Session("Upsw")
orderid=Request("txtOrderid")
face=Request("R1")
level=Request("txtLevel")
name=Request("txtName")
psw=Request("txtPsw")
work=Session("Uwork")
add=Session("Uadd")
eee=Session("Unid")
mail=Request("txtMail")
subject=Request("txtSubject")
ip=Request.ServerVariables("Remote_Addr")
If name ="" OR psw ="" Then
Response.Write"<font size=5 color=blue><center>"
Response.Write"<br>"
Response.Write"<br>"
Response.Write"請填寫你的名字/密碼～ <p>"
%>
<form name=form1>
<input type="button" name="btn1" value="返回" onClick="GoBack">
</form>
<%
Response.End
End If
If name<>name1 Or psw<>psw1 Then
Response.Write"<font size=5 color=blue><center>"
Response.Write"<br>"
Response.Write"<br>"
Response.Write"您的名字/密碼有錯誤，請仔細填寫！～ <p>"
%>
<form name=form1>
<input type="button" name="btn1" value="返回" onClick="GoBack">
</form>
<%
Response.End
End If
If subject="" Then
Response.Write"<font size=5 color=blue><center>"
Response.Write"<br>"
Response.Write"<br>"
Response.Write"請填寫您的發言主題～ <p>"
%>
<form name=form1>
<input type="button" name="btn1" value="返回" onClick="GoBack">
</form>
<%
Response.End
End If
IF orderid<>"" Then
j=Len(orderid)
mmm=Left(orderid,j-1)
Set conn = Server.CreateObject("ADODB.Connection")
DBPath=Server.MapPath("../fpdb/massege.mdb")
conn.Open"Driver={Microsoft Access Driver (*.mdb)};dbq="& DBPath
Set RS = conn.Execute("Select A_ID,A_OrderID From MASSEGE")
DO While not RS.EOF
nnn=RS("A_OrderID")
If Left(nnn,j-1)=mmm Then
aaa=Asc(Mid(nnn,j,1))
If aaa=122 Then
qqq=mmm+"a"+"z"
Else
qqq=mmm+Chr(aaa+1)+"z"
End If
End If
RS.MoveNext
Loop
RS.Close
conn.Close
Else
Set myconn = Server.CreateObject("ADODB.Connection")
DBPath=Server.MapPath("../fpdb/massege.mdb")
myconn.Open"Driver={Microsoft Access Driver (*.mdb)};dbq="& DBPath
SQLcmd1="Select * From MASSEGE Where A_Level = '0' Order By A_ID DESC"
Set RS = myconn.Execute(SQLcmd1)
nnn=RS("A_OrderID")
a=Asc(Left(nnn,1))
b=Asc(Mid(nnn,2,1))
c=Asc(Mid(nnn,3,1))
d=Asc(Mid(nnn,4,1))
e=Asc(Mid(nnn,5,1))
f=Asc(Mid(nnn,6,1))
%>
<%=Chr(a)%>11<%=Chr(b)%>22<%=Chr(c)%>33<%=Chr(d)%>44<%=Chr(e)%>55<%=Chr(f)%>66
<%
If f<122 Then
qqq=Chr(a)+Chr(b)+Chr(c)+Chr(d)+Chr(e)+Chr(f+1)+"z"
%>
<%=qqq%>77
<%
Else
If e<122 Then
qqq=Chr(a)+Chr(b)+Chr(c)+Chr(d)+Chr(e+1)+"az"
%>
<%=qqq%>88
<%
Else
If d<122 Then
qqq=Chr(a)+Chr(b)+Chr(c)+Chr(d+1)+"aaz"
%>
<%=qqq%>99
<%
End If
End If
End If
RS.Close
myconn.Close
End if
text=Server.HTMLEncode(Request("txtText"))
%>
<%=text%>
<%On error resume next
Set conn = Server.CreateObject("ADODB.Connection")
DBPath=Server.MapPath("../fpdb/massege.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};dbq="& DBPath
SQLcmd = "Insert Into MASSEGE(A_OrderID,A_Level,A_Name,A_NID,A_Work,A_Add,A_Mail,A_Subject,A_Text,A_IP,A_Time)Values('"&qqq&"','"&level&"','"&name&"','"&eee&"','"&work&"','"&add&"','"&mail&"','"&subject&"','"&text&"','"&ip&"','"&now&"')"
conn.Execute SQLcmd
conn.Close
Response.Redirect"succ.htm"
%>
</body>
顯示：（排序)main.asp
--------部分，未經優化處理-------
<%
Const adOpenStatic = 3
Const adLockPessimistic = 2
Set conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
DBPath=Server.MapPath("../fpdb/massege.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};dbq="& DBPath
SQLcmd="Select * From MASSEGE Order By A_OrderID Desc"
RS.Open SQLcmd,conn,adOpenStatic,adLockPessimistic
page = CLng(Request("txtpage"))
RS.PageSize = 30
If Page < 1 Then Page = 1
If page > RS.PageCount Then page = RS.PageCount
RS.AbsolutePage = page
%>
<form action="main.asp" method="get">
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="speak.asp" target="rbottom"><font color="#0000FF">發言</font></a></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="main.asp"><font color="#0000FF">刷新</font></a></td>
<td height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">留言筆數:<%=RS.RecordCount%></font></td>
<td height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">總頁數:<%=RS.PageCount%></font></td>
<td height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">目前頁次:<%=page%></font></td>
<td valign="top" align="left" height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">轉到<input type="text" name="txtpage" size="2" style="font-size: 8pt; border-style: dotted; border-width: 1">頁</font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00">
<font color="#0000FF">
<%
If page <> 1 Then
Response.Write"<a href=main.asp?txtpage=1>第一頁</a>"%></font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00">
<font color="#0000FF">
<%Response.Write"<a href=main.asp?txtpage="&(page - 1)&">上一頁</a>"%></font></td>
<%
End If
If page <>RS.PageCount Then%><td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00">
<font color="#0000FF">
<%Response.Write"<a href=main.asp?txtpage="&(page + 1)&">下一頁</a>" %></font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF"><%Response.Write"<a href=main.asp?txtpage="&RS.PageCount&">最后一頁</a>"
End If
%></font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="pob_massege.asp"><font color="#0000FF">精華</font></a></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="baoqian.htm"><font color="#0000FF">檢索</font></a></td>
<%
If Application("Ukingliu")="kingliu" Then
aaa="on"
Else
aaa="off"
End If
%>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">本版斑竹：<a href="mailto:[email protected]">滄海為水</a><img src="../images/<%=aaa%>.gif" width="15" height="15"></font></td>
</tr>
</table>
</form>
<%For ipage = 1 To RS.PageSize%>
.
.
.
（縮進，省略）
face=RS("A_Face")
mmm=gif&""&face&".gif"
%>
<table align="center" border="0" cellspacing="1" width="750" bgcolor="#BEBEDC">
<tr>
<td style="border-bottom: 1 solid #FFFF00"><%=aaa%>
<ul>
<li><img src="../images/<%=mmm%>"><a href="massege.asp?txtID=<%=RS("A_ID")%>" target="rbottom"><%=Server.HTMLEncode(RS("A_Subject"))%></a>
<%
If RS("A_Text")="" Then
Response.Write"<無內容>"
End If
%>
{ID:<%=RS("A_ID")%>}【<%=RS("A_Name")%>ID:<%=RS("A_NID")%>】<<%=RS("A_Time")%>>『點擊：<%=RS("A_Times")%>』</td>
</tr>
</table>
<%
RS.MoveNext
If RS.EOF Then Exit For
Next
RS.Close
conn.Close