http://223987.com/doc/425.html

參考文檔：《SQL語(yǔ)句循環(huán)》

老大，我在用這個(gè)SQL語(yǔ)句循環(huán)的時(shí)候，發(fā)現(xiàn)構(gòu)成 SQL語(yǔ)句的那一句，好像不能用動(dòng)態(tài)參數(shù)組成？

{?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}

按手冊(cè)的這句查詢的話，直接就錯(cuò)誤了

{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"