http://www.zbshanke.com/doc/425.html

參考文檔：《SQL語句循環》

老大，我在用這個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}

mysqli_sql_exception #1064

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"