#19982 [Opn->Fbk]: select from multiple tables fail

ID: 19982 Updated by: kalowsky@php.net Reported By: pptiezzi@erreuno.net -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: RedHat 6.2 PHP Version: 4.2.3 New Comment: hrm, any chance you can turn on SQL logging? Previous Comments: ------------------------------------------------------------------------ [2002-10-18 13:17:37] pptiezzi@erreuno.net I'm using Openlink Multi Tier Driver for accessing a Informix 7.2 Database on a Linux box from PHP scripts running on the Apache Web Server on a different Linux Box. PHP version 4.2.3 Openlink version 4.2.7 Apache Version 1.3.12 I'm tested Openlink driver and DSN setup with Openlink test program odbctest: It work fine. This script work fine: <? $db = odbc_connect("$dsn", "$user", "$password"); $sql = "Select codice,name,address from clienti where codice = '$codice'"; if($result = odbc_do($db, $sql)) {if($db1 = odbc_fetch_into($result, $myrow)) do{printf(" ........ }while((odbc_fetch_into($result, $myrow)); } ?> This script fail... (The same sql statement work fine with odbctest) <? $db = odbc_connect("$dsn", "$user", "$password"); $sql = "Select codice,name,address, zipnum from clienti, ziptable where codice = zipcode and codice = '$codice'"; if($result = odbc_do($db, $sql)) {// The $result connect string is OK and the correct // number of rows is returned.... $numrows = odbc_num_rows($result); // O.K. // Nothing is returned from the following function.. if($db1 = odbc_fetch_into($result, $myrow)) do{printf(" ........ }while((odbc_fetch_into($result, $myrow)); } ?> odbc_fetch_row also returns nothing. PHP configuration: ./configure' '--with-apxs=/usr/sbin/apxs' '--with-ftp' '--with-config-file-path=/etc/httpd' '--with-informix' '--with-iodbc=/usr/local/openlink/odbcsdk' ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19982&edit=1