ppypp伦理天堂,91手机在线视频,免费在线观看黄色毛片,夜夜穞天天穞狠狠穞AV美女按摩

聯系官方銷售客服

1835022288

028-61286886

投訴 已解決 統計數量標簽是不是不支持查詢這種的條件就可以或者這樣的條件就 3 0
老鐵666(全能人才) SVIP會員 OEM版權 2020-11-11 00:03:14 私信
迅睿CMS版本:4.3.12 #標簽 #category #like

統計數量標簽是不是不支持like查詢

{count action=sql sql='SELECT * FROM dr_1_share_category WHERE `dr_1_share_category`.`pid` IN (532) ' } {$debug_count}

這種的where條件就可以

{count action=sql sql='SELECT * FROM dr_1_share_category WHERE `dr_1_share_category`.`name` LIKE '%關鍵詞%' ' } {$debug_count}

或者

{count action=sql sql='SELECT * FROM dr_1_share_category WHERE name LIKE '%關鍵詞%' ' } {$debug_count}

這樣的where條件就報錯了 ,好像 '%關鍵詞%' 沒傳遞過去一樣

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

#SQL:SELECT count(*) as ct FROM dr_1_share_category where `dr_1_share_category`.`name` LIKE

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

#SQL:SELECT count(*) as ct FROM dr_1_share_category WHERE name LIKE

是不是要添加轉意符,怎么弄?指點下

解決方案