( 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;
程序中你要寫可以這樣寫
查詢匯總總數(shù)
$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();
要自己查數(shù)據(jù)庫然后加起來把
我記得章節(jié)不支持閱讀數(shù)量吧
回復(fù)@對方正在輸入
默認(rèn)好像是沒有，不過可以自己寫一個，加個文本字段就好了
用mysql sum函數(shù)，一條sql就搞定了，條件是按書的id去查，然后拿到那個字段用sum函數(shù)求和
這個是數(shù)據(jù)庫寫法，如果只需要hits的總和可以這樣寫，我是所有的都列出來了方便你學(xué)習(xí)
這個是用來查詢總的。
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;
程序中你要寫可以這樣寫
查詢匯總總數(shù)
$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();
這個是輸出匯總的總數(shù)，這樣就可以了，這兩段代碼就可以解決，104就是你那篇小說的id不是他下面的篇章的id，就是這個的id，代碼都寫好了，可以拿來直接用
echo $total[0]['total'];
沒有看懂樓上的回復(fù)。