tag关联其他字段调用显示
迅睿框架 更新 2023-11-12 20:14:40
xingliu
xingliu
标签解析：{related module=all field=id,title,url,keywords,tag1 tag=tag测试 page=1 pagesize=10 urlrule=/index.php?s=tag&name=tagceshi&page=[page]}
查询解析: SELECT count(*) as c FROM (SELECT id,title,url,keywords,tag1,'news' AS mid FROM `dr_1_news`) as my WHERE ((`title` LIKE "%tag测试%" OR `keywords` LIKE "%tag测试%")) ORDER BY NULL
当前路由：tag/home/index
动态地址：index.php?s=tag&name=tagceshi
没有查询到内容
变量前缀：t
总记录数：0
分页功能：未开启怎么把
WHERE ((`title` LIKE "%tag测试%" OR `keywords` LIKE "%tag测试%"))
改成
WHERE ((`title` LIKE "%tag测试%" OR `tag1` LIKE "%tag测试%"))
{php $ss=urlencode('SELECT count(*) as c FROM (SELECT id,title,url,keywords,tag1,\'news\' AS mid FROM `dr_1_news`) as my WHERE ((`title` LIKE "%tag测试%" OR `tag1` LIKE "%tag测试%")) ORDER BY NULL');} {sql sql='$ss'} {/sql} {$debug}{php $ss=urlencode('SELECT count(*) as c FROM (SELECT id,title,url,keywords,tag1,\'news\' AS mid FROM `dr_1_news`) as my WHERE ((`title` LIKE "%tag测试%" OR `tag1` LIKE "%tag测试%")) ORDER BY NULL');} {sql sql='$ss'} <li><a href="{$t.url}" class="title">{$t.title}</a></li> {/sql} <li><a href="{$t.url}" class="title">{$t.title}</a></li> 显示不出数据 {$debug}显示已经有数据