{eval $q2 = $db->query("SELECT p.zy_postinner,p.authorid,t.subject,p.tid,p.fid FROM cdb_posts p LEFT JOIN cdb_threads t ON t.tid=p.tid WHERE p.pid = " . $_GET[pid]);}
{eval $asdfgh = $db->fetch_array($q2);}
{eval $q2=$db->fetch_array($db->query("SELECT * FROM zy_postinner WHERE pid=".$_GET[pid]." and ptid=".$_GET[ptid]));}
{eval $q2 = $db->query("SELECT ptid FROM zy_postinner ORDER BY ptid DESC LIMIT 1");}
{eval $ptid = $db->fetch_array($q2);}
{eval $q2 = $db->query("SELECT p.zy_postinner,p.authorid,t.subject,p.tid,p.fid FROM cdb_posts p LEFT JOIN cdb_threads t ON t.tid=p.tid WHERE p.pid = " . $pid);}
{eval $asdfgh = $db->fetch_array($q2);}
<!--{if $toptid>0}-->
{eval $q2=$db->query("SELECT uid,name FROM zy_postinner WHERE ptid = " . $toptid);}
{eval $c=$db->fetch_array($q2);}
<!--{if $c[uid]>0}-->
{eval $q2=$db->query("SELECT id FROM cdb_promptmsgs ORDER BY id DESC LIMIT 1");}
如果不想知道原理,仅仅想要实现效果,so easy,具体操作是:
【1】本帖3楼 也就是步骤2 新建的aa_zyhome_postinner模版
找到
WHERE pid = $pid ORDER BY ptid DESC LIMIT $upper,5" 去掉里面的DESC即可,去掉后酱紫:
WHERE pid = $pid ORDER BY ptid LIMIT $upper,5"
【2】本帖7楼 也就是步骤6 修改的 viewthread_node模版
找到
ORDER BY ptid DESC LIMIT 5 去掉里面的DESC即可,去掉后酱紫:
ORDER BY ptid LIMIT 5作者: 麻城生活网 时间: 2018-9-7 12:24
本帖最后由 麻城生活网 于 2018-9-10 09:30 编辑
想造如何升序排列吗?
原理在“[sql代码]乱七八糟”一文8楼。
如果不想知道原理,仅仅想要实现效果,so e ...
flashroad 发表于 2018-8-29 13:05