PHP 4.0 Bug #5719 Updated: lost result entry when using sybase_fetch_row()

ID: 5719 Updated by: sniper Reported By: torsten.weigel@dresdner-bank.com Status: Feedback Bug Type: Sybase (dblib) related Assigned To: Comments: Does this problem still exist with php4.0.2 ? --Jani Previous Comments: [2000-07-25 11:05:26] torsten.weigel@dresdner-bank.com Additional Information: The reported problem occures in PHP 4.0 pl2. --------------------------------------------------------------------------- [2000-07-24 23:07:32] waldschrott@php.net Please verify, that it´s still happening using the latest version of PHP (release 4.0.1pl2 or CVS). --------------------------------------------------------------------------- [2000-07-21 10:42:19] torsten.weigel@dresdner-bank.com system decription: - SUN E450 4xUltraSparc II 250 MHz, 1GB memory - Solaris 2.6 (all recomended patches) - Sybase Adaptive Server Enterprise/11.9.2/1031/P/Sun_svr4/OS 5.5.1/FBO/Fri Aug 14 06:26:45 1998 php configuration line: ./configure --with-apxs=/opt/apache/bin/apxs --with-config-file-path=/opt/apache/conf --with-mm=../../mm-1.1.2/mm-binary --without-mysql --with-sybase=/opt/db/sybase/sybase11.9.2 --with-pdflib=/usr/local/lib --with-gd=../addons/gd-1.8.3 --with-jpeg-dir=/usr/local --with-xpm-dir=/usr/local --with-ttf=/usr/local --with-mhash=/usr/local --enable-libgcc --enable-track-vars --enable-url-includes sample script: <?php $db_id=sybase_connect("DSCOMPONENTS_DEV", "", ""); if(!$db_id) { print ("Connect to database fails<BR>"); } else { print ("Connection established<BR>"); $rc=sybase_select_db("master"); $db_result=sybase_query("select * from sysusers order by name"); $selected_rows=sybase_num_rows($db_result); print ("Selected Rows= $selected_rows<BR>"); /*Funny stuff !! Activate the next line and fix the problem*/ /*$rc=sybase_data_seek($db_result,0);*/ while ($db_row = sybase_fetch_row($db_result)) { print (implode($db_row, " : ")); print ("<BR>"); } } ?> description: The sample script loses usually the second result line. If the error does not turn up in the first time, make a reload for the same page an then you got it. It is not relevant how to order the result, everytime the second line is empty. The line with the sybase_data_seek-statement fixes the problem. Regards Torsten --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=5719