SELECT * FROM dr_1_home WHERE fuwuquyu='1' AND FIND_IN_SET('"8"',scly)
数据库sql查询结果,如何写模板,显示查询结果呢
{list action=sql module=news sql='select * from @#1_news' page=1 pagesize=10 urlrule=index.php?page=[page]}
{$t.title}<br>
{/list}
{$pages}
{$error}
帮助文档的方法试了多次,都显示系统故障
模板文件:
URL地址:
{php $sql = urlencode("SELECT * FROM dr_1_home WHERE fuwuquyu='1' AND FIND_IN_SET('\"8\"',scly)");}
{list action=sql module=home sql='$sql' page=1 pagesize=10 urlrule=index.php?page=[page]}
{$t.title}<br>
{/list}
{$pages}
{$debug}niyufaxiecuole参考文档:《SQL语句循环》
标签里面不能出现”号
特别感谢各位高人! @迅睿框架创始人