Re: odbc_execute

ANZOLA Silvio wrote:

Hi; I'm e newbie in PHP. I have to reda data from an AS400 system; I use an ODBC connection and I have to read data from a table with This the SQL Statement " $query_stm = "SELECT * " . "FROM cordo.plavt " . "where atcdim = ? " . "and atdtvf = 9999999"; This is the prepare statement : $result = odbc_prepare ($dbconn, $query_stm); This is the execute statement $exc = odbc_execute ($result, array($Targa)); I test the execution of the odbc_execute and I have TRUE, so all works fine; But now how can retrieve the data from the result set? ; It seems thet all the fetch function work with the odbc_exec statement;

See comment here: http://www.php.net/manual/en/function.odbc-prepare.php#71616 You need to pass the $result from the prepare statement to the _fetch_* functions. -- Postgresql & php tutorials http://www.designmagick.com/