Php + pixel El problems? PHPcode $ strSql & quot; SELECTBUYER_ID, question % & quot; $ connodbc_connect (cle, evlp, evlp, SQL _CUR_U php + pixel?
PHP code
$ StrSql = "SELECT BUYER_ID, BUYER_NAME FROM apps. buyr_info WHERE BUYER_NAME LIKE 'a % '"; $ conn = odbc_connect ('Cle', 'evlp ', 'evlp', SQL _CUR_USE_ODBC) or die (" cannot connect to the data source "); $ result = odbc_do ($ conn, $ strSql) or die ("declaration not executed"); while (odbc_fetch_row ($ result) {$ BUYER_NAME = odbc_result ($ result, 1); echo "mm nn pp"; echo $ BUYER_NAME ;}
I run the above code
No value is obtained on the interface 《.
I separately put $ strSql into Pl/SQL to get multiple records ..
If I replace the SQL statement
SQL code
$strSql = "SELECT BUYER_ID, BUYER_NAME FROM apps.buyr_info ";
Now the page will be able to get a record <〈,
What is the reason...
------ Solution --------------------
Directly dump $ result.