From: [EMAIL PROTECTED]
Operating system: RedHat 6.2
PHP version: 4.2.3
PHP Bug Type: ODBC related
Bug description: select from multiple tables fail
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 bug report at http://bugs.php.net/?id=19982&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=19982&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=19982&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=19982&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=19982&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=19982&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=19982&r=support
Expected behavior: http://bugs.php.net/fix.php?id=19982&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=19982&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=19982&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=19982&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=19982&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=19982&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=19982&r=isapi
