( SELECT sum( hits ) FROM dr_1_book_extend WHERE cid = 104 ) as total
FROM
dr_1_book AS a
INNER JOIN dr_1_book_extend AS b ON b.cid = a.id
WHERE
b.cid = 104;
程序中你要寫可以這樣寫
查詢匯總總數
$total = \Phpcmf\Service::M()->db->query('SELECT ( SELECT sum( hits ) FROM dr_1_book_extend WHERE cid = 104 ) as total FROM dr_1_book AS a INNER JOIN dr_1_book_extend AS b ON b.cid = a.id WHERE b.cid = 104;')->getResultArray();
要自己查數據庫然后加起來把
我記得章節不支持閱讀數量吧
回復@對方正在輸入
默認好像是沒有，不過可以自己寫一個，加個文本字段就好了
用mysql sum函數，一條sql就搞定了，條件是按書的id去查，然后拿到那個字段用sum函數求和
這個是數據庫寫法，如果只需要hits的總和可以這樣寫，我是所有的都列出來了方便你學習
這個是用來查詢總的。
SELECT
( SELECT sum( hits ) FROM dr_1_book_extend WHERE cid = 104 ) as total
FROM
dr_1_book AS a
INNER JOIN dr_1_book_extend AS b ON b.cid = a.id
WHERE
b.cid = 104;
程序中你要寫可以這樣寫
查詢匯總總數
$total = \Phpcmf\Service::M()->db->query('SELECT ( SELECT sum( hits ) FROM dr_1_book_extend WHERE cid = 104 ) as total FROM dr_1_book AS a INNER JOIN dr_1_book_extend AS b ON b.cid = a.id WHERE b.cid = 104;')->getResultArray();
這個是輸出匯總的總數，這樣就可以了，這兩段代碼就可以解決，104就是你那篇小說的id不是他下面的篇章的id，就是這個的id，代碼都寫好了，可以拿來直接用
echo $total[0]['total'];
沒有看懂樓上的回復。