ID: 19982
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-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] [EMAIL PROTECTED]
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
