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 "%上海動畫制作%")) ,應(yīng)該有 tag=$tag.tags 就不應(yīng)該再去匹配標(biāo)題和關(guān)鍵詞了。`dj_1_news`.`tag` = "上海動畫制作"這里也不應(yīng)該是=,因?yàn)橥粭l內(nèi)容會有多個(gè)tag標(biāo)簽
這個(gè)是相關(guān)內(nèi)容,和tag沒多少關(guān)系啊,不安插件也可以使用的
回復(fù)@吉祥三寶 安裝了插件才能使用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 "%上海動畫制作%")) ,應(yīng)該有 tag=$tag.tags 就不應(yīng)該再去匹配標(biāo)題和關(guān)鍵詞了。`dj_1_news`.`tag` = "上海動畫制作"這里也不應(yīng)該是=,因?yàn)橥粭l內(nèi)容會有多個(gè)tag標(biāo)簽
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 "%上海動畫制作%")) ,
應(yīng)該有 tag=$tag.tags 就不應(yīng)該再去匹配標(biāo)題和關(guān)鍵詞了。
`dj_1_news`.`tag` = "上海動畫制作"這里也不應(yīng)該是=,因?yàn)橥粭l內(nèi)容會有多個(gè)tag標(biāo)簽
tag標(biāo)簽和關(guān)鍵字是一起的嗎?