ID: 29180 Updated by: [EMAIL PROTECTED] Reported By: tila at home dot nl -Status: Open +Status: Feedback Bug Type: PostgreSQL related Operating System: Linux 2.4.24 PHP Version: 5.0.0 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [2004-07-18 00:33:45] tila at home dot nl 42 by the way is the number of records in the database. So $offset takes the value of $total ------------------------------------------------------------------------ [2004-07-16 10:34:23] tila at home dot nl No, When I remove the PEAR::DB class and the code that's using it, it will display '5' just as expected. When I use pg_exec and pg_fetch_row etc.. the result displays '42' ???? <?php $db = pg_connect("host=localhost user=apache password=apache dbname=groupware");$QUERY = "SELECT o.* FROM personoverview o"; $result = pg_exec($QUERY); $total = pg_numrows($result); $offset = $_GET['id']?$_GET['id']:0; $perpage = 10; for ($i = $offset; (($i < $total) && ($i < ($offset + $perpage))); $i++) { $row = pg_fetch_row($result, $i); } echo $offset; ?> ------------------------------------------------------------------------ [2004-07-16 00:59:04] [EMAIL PROTECTED] does it also crash when NOT using the PEAR::DB class? ------------------------------------------------------------------------ [2004-07-16 00:40:32] tila at home dot nl new code, I am sorry. I cannot provide a link to the server. open it with ?id=5 as parameter. <?php require_once ('DB.php'); $dsn = "pgsql://apache:[EMAIL PROTECTED]/groupware"; $db = DB::connect($dsn, true); $QUERY = "SELECT o.* FROM personoverview o"; $result = $db->query($QUERY); $total = $result->numRows(); $offset = $_GET['id']?$_GET['id']:0; $perpage = 10; for ($i = $offset; (($i < $total) && ($i < ($offset + $perpage))); $i++) { $row = $result->fetchRow(DB_FETCHMODE_ASSOC, $i); } echo $offset; ?> ------------------------------------------------------------------------ [2004-07-15 11:50:43] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try avoid embedding huge scripts into the report. ------------------------------------------------------------------------ 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/29180 -- Edit this bug report at http://bugs.php.net/?id=29180&edit=1
