谁能帮忙解释一下数据库PK_read中posttime生成是怎么算的

pkx001 pkx001 关注 四级站长 普通
发表于用户提问版块 小白问题,普通问题
数据库PK_read中posttime生成是怎么算的,如下表<p><p class="cRsz" style="position: absolute; height: 954px;"><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 210.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 257.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 286.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 326.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 433.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 500.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 560.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 648.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 719.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 782.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 874.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 946.312px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1001.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1106.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1137.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1174.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1278.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1321.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1353.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1441.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1496.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1516.31px;"></p><p class="colborder" style="cursor: col-resize; height: 954px; margin-left: -6px; position: absolute; width: 5px; left: 1557.31px;"></p></p><table id="table_results" class="ajax pma_table"><thead><tr><th colspan="4" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60posttime%60+ASC&amp;goto=sql.php&amp;full_text_button=1&amp;display_text=F&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;"><img class="fulltext" src="http://snhk1002.suanisp.com:306/themes/pmahomme/img/s_fulltext.png" alt="完整内容" title="完整内容" style="vertical-align: middle;"></a></th><th class="draggable column_heading pointer marker" data-column="id" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60id%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">id</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章的id</span></span></th><th class="draggable column_heading pointer marker" data-column="sortid" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60sortid%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">sortid</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章所属版块id</span></span></th><th class="draggable column_heading pointer marker" data-column="uid" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60uid%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">uid</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">发布人uid</span></span></th><th class="draggable column_heading pointer marker" data-column="title" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60title%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">title</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章标题</span></span></th><th class="draggable column_heading pointer marker" data-column="content" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60content%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">content</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章内容</span></span></th><th class="draggable column_heading pointer marker" data-column="looknum" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60looknum%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">looknum</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">浏览次数</span></span></th><th class="draggable column_heading pointer marker" data-column="zannum" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60zannum%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">zannum</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">被赞次数</span></span></th><th class="draggable column_heading pointer marker" data-column="posttime" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60posttime%60++DESC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">posttime&nbsp;<img src="http://snhk1002.suanisp.com:306/themes/dot.gif" title="" alt="递增" class="icon ic_s_asc soimg7" style="vertical-align: middle; margin-right: 0.3em; margin-left: 0.3em; width: 16px; height: 16px; display: inline; background-image: url(&quot;./themes/pmahomme/img/sprites.png&quot;) !important; background-repeat: no-repeat !important; background-position: 0px -1792px !important;"></a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">发布时间</span></span></th><th class="draggable column_heading pointer marker" data-column="readlevel" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60readlevel%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">readlevel</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章阅读权限</span></span></th><th class="draggable column_heading pointer marker" data-column="replyuid" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60replyuid%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">replyuid</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">最后回复人uid</span></span></th><th class="draggable column_heading pointer marker" data-column="replycontent" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60replycontent%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">replycontent</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">最新回复内容</span></span></th><th class="draggable column_heading pointer marker" data-column="replytime" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60replytime%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">replytime</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">最后回复时间</span></span></th><th class="draggable column_heading pointer marker" data-column="replyip" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60replyip%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">replyip</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">最后回复人的ip</span></span></th><th class="draggable column_heading pointer marker" data-column="postip" aria-describedby="ui-tooltip-50" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60postip%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">postip</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">发布人的ip</span></span></th><th class="draggable column_heading pointer marker" data-column="top" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60top%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">top</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章置顶</span></span></th><th class="draggable column_heading pointer marker" data-column="high" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60high%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">high</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章精华</span></span></th><th class="draggable column_heading pointer marker" data-column="replyafterlook" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60replyafterlook%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">replyafterlook</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">回复后可见</span></span></th><th class="draggable column_heading pointer marker" data-column="data" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60data%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">data</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">文章其他数据</span></span></th><th class="draggable column_heading pointer marker" data-column="del" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60del%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">del</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">1为删除,0为正常</span></span></th><th class="draggable column_heading pointer marker" data-column="activetime" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; cursor: move;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60activetime%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">activetime</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">最后活动时间</span></span></th><th class="draggable column_heading pointer marker" data-column="replyid" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60replyid%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">replyid</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">回复的id</span></span></th><th class="draggable column_heading pointer marker" data-column="fs" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60fs%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">fs</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">回复的楼层数</span></span></th><th class="draggable column_heading pointer marker" data-column="label" style="color: rgb(0, 0, 0); background-image: -webkit-linear-gradient(top, rgb(255, 255, 255), rgb(204, 204, 204)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-right: 1px solid rgb(255, 255, 255); text-align: left; padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px;"><span style="display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60label%60+ASC&amp;session_max_rows=30&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;">label</a><span class="tblcomment" style="font-size: 12px; font-weight: normal; color: rgb(0, 0, 153); display: block; overflow: hidden;">标签</span></span></th></tr></thead><tbody><tr class="odd" style="background: rgb(255, 255, 255); color: rgb(68, 68, 68); font-family: sans-serif; font-size: 13.12px;"><td class="center" style="padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; text-align: center; position: static;"><span style="display: block; overflow: hidden;"></span></td><td class="edit_row_anchor center" style="padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; text-align: center; position: static;"><span class="nowrap" style="white-space: nowrap; display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/tbl_change.php?db=a1021093125&amp;table=bbq001_read&amp;where_clause=%60bbq001_read%60.%60id%60+%3D+5&amp;clause_is_unique=1&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60posttime%60+ASC&amp;goto=sql.php&amp;default_action=update&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;"><span class="nowrap" style="display: block; overflow: hidden;"><img src="http://snhk1002.suanisp.com:306/themes/dot.gif" title="编辑" alt="编辑" class="icon ic_b_edit" style="vertical-align: middle; width: 16px; height: 16px; background-image: url(&quot;./themes/pmahomme/img/sprites.png&quot;) !important; background-repeat: no-repeat !important; background-position: 0px -512px !important;">&nbsp;编辑</span></a></span></td><td class="center" style="padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; text-align: center; position: static;"><span class="nowrap" style="white-space: nowrap; display: block; overflow: hidden;"><a href="http://snhk1002.suanisp.com:306/tbl_change.php?db=a1021093125&amp;table=bbq001_read&amp;where_clause=%60bbq001_read%60.%60id%60+%3D+5&amp;clause_is_unique=1&amp;sql_query=SELECT+%2A+FROM+%60bbq001_read%60%0AORDER+BY+%60bbq001_read%60.%60posttime%60+ASC&amp;goto=sql.php&amp;default_action=insert&amp;token=dfbcecd01b253b01a231b84959693cd2" style="color: rgb(35, 90, 129); cursor: pointer;"><span class="nowrap" style="display: block; overflow: hidden;"><img src="http://snhk1002.suanisp.com:306/themes/dot.gif" title="复制" alt="复制" class="icon ic_b_insrow" style="vertical-align: middle; width: 16px; height: 16px; background-image: url(&quot;./themes/pmahomme/img/sprites.png&quot;) !important; background-repeat: no-repeat !important; background-position: 0px -768px !important;">&nbsp;复制</span></a></span></td><td class="center" style="padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; text-align: center; position: static;"><a href="http://snhk1002.suanisp.com:306/sql.php?db=a1021093125&amp;table=bbq001_read&amp;sql_query=DELETE+FROM+%60a1021093125%60.%60bbq001_read%60+WHERE+%60bbq001_read%60.%60id%60+%3D+5&amp;message_to_show=%E5%B7%B2%E5%88%A0%E9%99%A4%E8%AF%A5%E8%A1%8C&amp;goto=sql.php%3Fdb%3Da1021093125%26table%3Dbbq001_read%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560bbq001_read%2560%250AORDER%2BBY%2B%2560bbq001_read%2560.%2560posttime%2560%2BASC%26message_to_show%3D%25E5%25B7%25B2%25E5%2588%25A0%25E9%2599%25A4%25E8%25AF%25A5%25E8%25A1%258C%26goto%3Dsql.php%26token%3Ddfbcecd01b253b01a231b84959693cd2&amp;token=dfbcecd01b253b01a231b84959693cd2" class="delete_row ajax" style="color: rgb(35, 90, 129); cursor: pointer;"><span class="nowrap" style="white-space: nowrap; display: block; overflow: hidden;"><img src="http://snhk1002.suanisp.com:306/themes/dot.gif" title="删除" alt="删除" class="icon ic_b_drop" style="vertical-align: middle; width: 16px; height: 16px; background-image: url(&quot;./themes/pmahomme/img/sprites.png&quot;) !important; background-repeat: no-repeat !important; background-position: 0px -432px !important;">&nbsp;删除</span></a></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">5</span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">4</span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">5</span></td><td class="left data grid_edit click2 not_null " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">建站者</span></td><td class="left data grid_edit click2 not_null truncated" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">...</span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">1</span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="right data grid_edit click2 not_null nowrap marked" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; background: -webkit-linear-gradient(top, rgb(206, 214, 223), rgb(182, 198, 215)); color: rgb(0, 0, 0); position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">1517369177</span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">2</span></td><td class="data grid_edit click2 null" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; font-style: italic; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;"><i>NULL</i></span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="data grid_edit click2 null" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; font-style: italic; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;"><i>NULL</i></span></td><td class="data grid_edit click2 hover" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; background: -webkit-linear-gradient(top, rgb(206, 214, 223), rgb(182, 198, 215)); color: rgb(0, 0, 0); position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">120.230.***.***</span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="data grid_edit click2 null" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; font-style: italic; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;"><i>NULL</i></span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="right data grid_edit click2 not_null nowrap" style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">1517369177</span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">0</span></td><td class="right data grid_edit click2 not_null nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; text-align: right; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;">1</span></td><td class="data grid_edit click2 nowrap " style="padding: 0.3em; margin-bottom: 12px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: nowrap; position: static; border-right: 1px solid rgb(187, 187, 187);"><span style="display: block; overflow: hidden;"></span></td></tr><tr class="even" style="background: rgb(223, 223, 223); color: rgb(68, 68, 68); font-family: sans-serif; font-size: 13.12px;"><td class="center" style="padding: 0.3em; margin: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; text-align: center; position: static;"></td></tr></tbody></table></p>
评论列表 评论
pkx001 pkx001 四级站长 普通 2#
表格在网页中显示不出来,只能发图了Image
共0条回复,点击查看回复
puyuetian 乐天 九级站长 创始人 3#
php的time()函数

pkx001:
在哪个文件里?还是在.hst文件里

共0条回复,点击查看回复
发布评论

评论: 谁能帮忙解释一下数据库PK_read中posttime生成是怎么算的

已有0次打赏
(5) 分享
分享

请保存二维码或复制链接进行分享

取消