聯(lián)系官方銷售客服
1835022288
028-61286886
文章模塊(News)里的文章做了聯(lián)動(dòng)地區(qū)(address)的歸類,現(xiàn)在想要在首頁單獨(dú)調(diào)取地區(qū)(address)為北京、上海、廣州的的數(shù)據(jù)
取一個(gè)地區(qū)的數(shù)據(jù)如下:
{module module=news catid=23 num=12 address=beijing }
問題:取2個(gè)、3個(gè)的數(shù)據(jù)需要怎么寫
官方提醒:使用module內(nèi)容循環(huán)標(biāo)簽的生成工具,填寫參數(shù)就可以生成相關(guān)的代碼,每個(gè)參數(shù)后面都有用法解釋
問題:同時(shí)取2個(gè)、3個(gè)地區(qū)的數(shù)據(jù)需要怎么寫
{module module=news catid=23 num=12 JSON_address=2|3 }
這樣試一試
like標(biāo)簽?zāi)?/p>
出不來
like不是模糊匹配查詢嗎
{module module=news catid=23 num=12 JSON_address=2|3 }
{module}
{$debug}看看調(diào)試數(shù)據(jù)呢
回復(fù)迅??蚣軇?chuàng)始人
SQL: SELECT * FROM `dr_1_news` WHERE (`dr_1_news`.`address` LIKE "%\"聯(lián)動(dòng)單選字段(address)沒有找到對(duì)應(yīng)的聯(lián)動(dòng)菜單[address]的別名值[beijing\"%" OR `dr_1_news`.`address` LIKE "%\"tianjin]\"%") AND `dr_1_news`.`catid` = 23 AND `dr_1_news`.`status` = 9 ORDER BY `dr_1_news`.`updatetime` DESC LIMIT 12
{module module=news catid=23 num=12 address=2|3 }
{module}
{$debug}
SQL: SELECT * FROM `dr_1_news` WHERE `dr_1_news`.`catid` = 23 AND `dr_1_news`.`status` = 9 ORDER BY `dr_1_news`.`updatetime` DESC LIMIT 12
回復(fù)迅??蚣軇?chuàng)始人
SQL: SELECT * FROM `dr_1_news` WHERE `dr_1_news`.`address` = "聯(lián)動(dòng)單選字段(address)沒有找到對(duì)應(yīng)的聯(lián)動(dòng)菜單[address]的別名值[beijing|tianjin]" AND `dr_1_news`.`catid` = 23 AND `dr_1_news`.`status` = 9 ORDER BY `dr_1_news`.`updatetime` DESC LIMIT 12
回復(fù)迅??蚣軇?chuàng)始人
文件 /dayrui/Fcms/Core/View.php
改成Linkage試一試
回復(fù)迅??蚣軇?chuàng)始人 還是沒出數(shù)據(jù) ??
SQL: SELECT * FROM `dr_1_news` WHERE (`dr_1_news`.`address` LIKE "%\"1\"%" OR `dr_1_news`.`address` LIKE "%\"390\"%" OR `dr_1_news`.`address` LIKE "%\"392\"%" OR `dr_1_news`.`address` LIKE "%\"394\"%" OR `dr_1_news`.`address` LIKE "%\"395\"%" OR `dr_1_news`.`address` LIKE "%\"396\"%" OR `dr_1_news`.`address` LIKE "%\"397\"%" OR `dr_1_news`.`address` LIKE "%\"398\"%" OR `dr_1_news`.`address` LIKE "%\"399\"%" OR `dr_1_news`.`address` LIKE "%\"400\"%" OR `dr_1_news`.`address` LIKE "%\"401\"%" OR `dr_1_news`.`address` LIKE "%\"402\"%" OR `dr_1_news`.`address` LIKE "%\"403\"%" OR `dr_1_news`.`address` LIKE "%\"404\"%" OR `dr_1_news`.`address` LIKE "%\"405\"%" OR `dr_1_news`.`address` LIKE "%\"406\"%" OR `dr_1_news`.`address` LIKE "%\"407\"%" OR `dr_1_news`.`address` LIKE "%\"2\"%" OR `dr_1_news`.`address` LIKE "%\"408\"%" OR `dr_1_news`.`address` LIKE "%\"409\"%" OR `dr_1_news`.`address` LIKE "%\"410\"%" OR `dr_1_news`.`address` LIKE "%\"411\"%" OR `dr_1_news`.`address` LIKE "%\"412\"%" OR `dr_1_news`.`address` LIKE "%\"413\"%" OR `dr_1_news`.`address` LIKE "%\"414\"%" OR `dr_1_news`.`address` LIKE "%\"415\"%" OR `dr_1_news`.`address` LIKE "%\"416\"%" OR `dr_1_news`.`address` LIKE "%\"417\"%" OR `dr_1_news`.`address` LIKE "%\"418\"%" OR `dr_1_news`.`address` LIKE "%\"419\"%" OR `dr_1_news`.`address` LIKE "%\"420\"%" OR `dr_1_news`.`address` LIKE "%\"421\"%" OR `dr_1_news`.`address` LIKE "%\"422\"%" OR `dr_1_news`.`address` LIKE "%\"423\"%") AND `dr_1_news`.`catid` = 23 AND `dr_1_news`.`status` = 9 ORDER BY `dr_1_news`.`updatetime` DESC LIMIT 12
那就是不支持這種功能,等下個(gè)版本我開發(fā)這個(gè)功能
回復(fù)迅??蚣軇?chuàng)始人
好的,謝謝。
回復(fù)迅睿框架創(chuàng)始人 哇,這么快就更新,6666
回復(fù)迅??蚣軇?chuàng)始人
更新完后可以調(diào)取,JSON_和IN_都可以用,用哪個(gè)好
{module module=news catid=23 num=12 address=2|3 }
這個(gè)好