Smarty? SQL error
$ SQL = sprintf ("select * from table"); if (! $ Error = $ conn-> query ($ SQL) {$ results = array (); while (! ($ Error = $ conn-> fetchArray ($ results) {// This sentence has a problem. // I can read data locally and put it in the official service, once read, it stops ..............................}}
How can I modify it ??
Reply to discussion (solution)
What error is reported, whether the method does not exist, or how?
For if (! $ Error = $ conn-> query ($ SQL )){
Only when $ conn-> query ($ SQL) returns false will it enter the then Branch
When $ conn-> query ($ SQL) returns false, it indicates that the command string $ SQL is wrong!
Similarly, while (! ($ Error = $ conn-> fetchArray ($ results ))){
It also enters the loop body only when $ conn-> fetchArray returns false.
This is irrelevant to smarty. smarty does not provide database operations.