#33238 [Fbk-Opn]: Bug select odbc_fetch_row
ID: 33238 User updated by: olivier at pipas dot org Reported By: olivier at pipas dot org -Status: Feedback +Status: Open Bug Type: ODBC related Operating System: Windows XP PHP Version: 5.*, 4.* (2005-06-04) New Comment: Sorry, sorry It's not a bug : mysql_fetch_row return an array pgsql_fetch_row return an array mssql_fetch_row return an array but... odbc_fetch_row return an boolean ! (why ???) I must use odbc_result after... Previous Comments: [2005-06-04 01:07:59] [EMAIL PROTECTED] And how can we reproduce this? (we need the db..) [2005-06-03 23:26:55] olivier at pipas dot org I have tried this version (5.0.5-dev) but the bug is always present. This bug is also present in 5.0.0 and 4.3.11 [2005-06-03 22:59:21] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip [2005-06-03 22:15:51] olivier at pipas dot org I have tested with odbc_fetch_object, and it's working ! So : it's a bug in function odbc_fetch_row [2005-06-03 22:09:55] olivier at pipas dot org I use apache 2 and php as an Apache module The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/33238 -- Edit this bug report at http://bugs.php.net/?id=33238edit=1
#33238 [NEW]: Bug select odbc_fetch_row
From: olivier at pipas dot org
Operating system: Windows XP
PHP version: 5.0.4
PHP Bug Type: ODBC related
Bug description: Bug select odbc_fetch_row
Description:
I do a select in a db access (odbc), it return good number of rows but
cannot show it
Reproduce code:
---
if(!$conn=odbc_connect(mydbodbc,user,pass))
exit(Error connect DB);
$sql=SELECT numcountry, namecountry FROM countries;;
if(!$res=odbc_exec($conn,$sql))
exit(Error syntax : $sql);
$i=0;
while($restab=odbc_fetch_row($res))
{
echo $restab;
echo $restab[0] $restab[1]br\n;
$i++;
}
echo $i;
Expected result:
Array1 Belgiumbr
Array2 Francebr
Array3 Spainbr
3
Actual result:
--
1 br
1 br
1 br
3
--
Edit bug report at http://bugs.php.net/?id=33238edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33238r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=33238r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=33238r=trysnapshot51
Fixed in CVS:http://bugs.php.net/fix.php?id=33238r=fixedcvs
Fixed in release:http://bugs.php.net/fix.php?id=33238r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=33238r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=33238r=needscript
Try newer version: http://bugs.php.net/fix.php?id=33238r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=33238r=support
Expected behavior: http://bugs.php.net/fix.php?id=33238r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=33238r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=33238r=submittedtwice
register_globals:http://bugs.php.net/fix.php?id=33238r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33238r=php3
Daylight Savings:http://bugs.php.net/fix.php?id=33238r=dst
IIS Stability: http://bugs.php.net/fix.php?id=33238r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=33238r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=33238r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=33238r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=33238r=mysqlcfg
#33238 [Opn]: Bug select odbc_fetch_row
ID: 33238
User updated by: olivier at pipas dot org
Reported By: olivier at pipas dot org
Status: Open
Bug Type: ODBC related
Operating System: Windows XP
PHP Version: 5.0.4
New Comment:
I use apache 2 and php as an Apache module
Previous Comments:
[2005-06-03 22:05:31] olivier at pipas dot org
Description:
I do a select in a db access (odbc), it return good number of rows but
cannot show it
Reproduce code:
---
if(!$conn=odbc_connect(mydbodbc,user,pass))
exit(Error connect DB);
$sql=SELECT numcountry, namecountry FROM countries;;
if(!$res=odbc_exec($conn,$sql))
exit(Error syntax : $sql);
$i=0;
while($restab=odbc_fetch_row($res))
{
echo $restab;
echo $restab[0] $restab[1]br\n;
$i++;
}
echo $i;
Expected result:
Array1 Belgiumbr
Array2 Francebr
Array3 Spainbr
3
Actual result:
--
1 br
1 br
1 br
3
--
Edit this bug report at http://bugs.php.net/?id=33238edit=1
#33238 [Opn]: Bug select odbc_fetch_row
ID: 33238
User updated by: olivier at pipas dot org
Reported By: olivier at pipas dot org
Status: Open
Bug Type: ODBC related
Operating System: Windows XP
PHP Version: 5.0.4
New Comment:
I have tested with odbc_fetch_object, and it's working !
So : it's a bug in function odbc_fetch_row
Previous Comments:
[2005-06-03 22:09:55] olivier at pipas dot org
I use apache 2 and php as an Apache module
[2005-06-03 22:05:31] olivier at pipas dot org
Description:
I do a select in a db access (odbc), it return good number of rows but
cannot show it
Reproduce code:
---
if(!$conn=odbc_connect(mydbodbc,user,pass))
exit(Error connect DB);
$sql=SELECT numcountry, namecountry FROM countries;;
if(!$res=odbc_exec($conn,$sql))
exit(Error syntax : $sql);
$i=0;
while($restab=odbc_fetch_row($res))
{
echo $restab;
echo $restab[0] $restab[1]br\n;
$i++;
}
echo $i;
Expected result:
Array1 Belgiumbr
Array2 Francebr
Array3 Spainbr
3
Actual result:
--
1 br
1 br
1 br
3
--
Edit this bug report at http://bugs.php.net/?id=33238edit=1
#33238 [Fbk-Opn]: Bug select odbc_fetch_row
ID: 33238
User updated by: olivier at pipas dot org
Reported By: olivier at pipas dot org
-Status: Feedback
+Status: Open
Bug Type: ODBC related
Operating System: Windows XP
PHP Version: 5.0.4
New Comment:
I have tried this version (5.0.5-dev) but the bug is always present.
This bug is also present in 5.0.0 and 4.3.11
Previous Comments:
[2005-06-03 22:59:21] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.0-win32-latest.zip
[2005-06-03 22:15:51] olivier at pipas dot org
I have tested with odbc_fetch_object, and it's working !
So : it's a bug in function odbc_fetch_row
[2005-06-03 22:09:55] olivier at pipas dot org
I use apache 2 and php as an Apache module
[2005-06-03 22:05:31] olivier at pipas dot org
Description:
I do a select in a db access (odbc), it return good number of rows but
cannot show it
Reproduce code:
---
if(!$conn=odbc_connect(mydbodbc,user,pass))
exit(Error connect DB);
$sql=SELECT numcountry, namecountry FROM countries;;
if(!$res=odbc_exec($conn,$sql))
exit(Error syntax : $sql);
$i=0;
while($restab=odbc_fetch_row($res))
{
echo $restab;
echo $restab[0] $restab[1]br\n;
$i++;
}
echo $i;
Expected result:
Array1 Belgiumbr
Array2 Francebr
Array3 Spainbr
3
Actual result:
--
1 br
1 br
1 br
3
--
Edit this bug report at http://bugs.php.net/?id=33238edit=1
