SQL: SELECT count(*) as c FROM `dj_1_news` WHERE `dj_1_news`.`tag` = "上海動畫制作" AND ((`dj_1_news`.`title` LIKE "%上海動畫制作%" OR `dj_1_news`.`keywords` LIKE "%上海動畫制作%")) AND `dj_1_news`.`status` = 9 ORDER BY NULL
這是有bug呀, AND ((`dj_1_news`.`title` LIKE "%上海動畫制作%" OR `dj_1_news`.`keywords` LIKE "%上海動畫制作%")) ,應該有 tag=$tag.tags 就不應該再去匹配標題和關鍵詞了。`dj_1_news`.`tag` = "上海動畫制作"這里也不應該是=,因為同一條內容會有多個tag標簽
這個是相關內容,和tag沒多少關系啊,不安插件也可以使用的
回復@吉祥三寶 安裝了插件才能使用tag=$tag.tags吧
debug一下
是這樣用的嗎
SQL: SELECT count(*) as c FROM `dj_1_news` WHERE `dj_1_news`.`tag` = "上海動畫制作" AND ((`dj_1_news`.`title` LIKE "%上海動畫制作%" OR `dj_1_news`.`keywords` LIKE "%上海動畫制作%")) AND `dj_1_news`.`status` = 9 ORDER BY NULL
這是有bug呀, AND ((`dj_1_news`.`title` LIKE "%上海動畫制作%" OR `dj_1_news`.`keywords` LIKE "%上海動畫制作%")) ,應該有 tag=$tag.tags 就不應該再去匹配標題和關鍵詞了。`dj_1_news`.`tag` = "上海動畫制作"這里也不應該是=,因為同一條內容會有多個tag標簽
SQL: SELECT count(*) as c FROM `dj_1_news` WHERE `dj_1_news`.`tag` = "上海動畫制作"
AND ((`dj_1_news`.`title` LIKE "%上海動畫制作%" OR `dj_1_news`.`keywords` LIKE "%上海動畫制作%"))
AND `dj_1_news`.`status` = 9 ORDER BY NULL
這是有bug呀, AND ((`dj_1_news`.`title` LIKE "%上海動畫制作%" OR `dj_1_news`.`keywords` LIKE "%上海動畫制作%")) ,
應該有 tag=$tag.tags 就不應該再去匹配標題和關鍵詞了。
`dj_1_news`.`tag` = "上海動畫制作"這里也不應該是=,因為同一條內容會有多個tag標簽
tag標簽和關鍵字是一起的嗎?