https://www.xunruicms.com/doc/425.html
老大,我在用这个SQL语句循环的时候,发现构成 SQL语句的那一句,好像不能用动态参数组成?
{?php
$query=urlencode('select * from @#1_news');
?}
{sql sql='$query' page=1 pagesize=10 urlrule=index.php?page=[page]}
{$t.title}<br>
{/sql}
{$pages}
{$debug}
按手册的这句查询的话,直接就错误了
{php $query=urlencode('select * from @#member where username="admin"');}
{sql sql='$query'}
{$t.username}
{/sql}
{$debug}You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@#member where username="admin"' at line 1
select * from @#member where username="admin"
