|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-02-04 12:35 UTC] iliaa@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 14:00:01 2025 UTC |
If I get the idea of pg_result_seek() right, instead of the following script $result = pg_query($db, $query); // some outside loop while ($whatever) { for ($i = 0; $i < pg_num_rows($result); $i++) { $row = pg_fetch_array($result, $i); // do something } } I should be able to write $result = pg_query($db, $query); // some outside loop while ($whatever) { pg_result_seek($result, 0); while ($row = pg_fetch_array($result)) { // do something } } The problem is, when I use it this way, it misses the first row (it looks like it iterated from the row nr 1, which is the second row in the result). I even tried to call pg_result_seek($result, -1), but, not surprisingly, it didn't work. PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 Configure Command './configure' '--with-pgsql=/usr/local/pgsql' '--with-pdflib=/usr/local' '--with-swf' '--with-apxs=/usr/local/apache/bin/apxs' '--enable-magic-quotes' '--disable-track-vars' '--without-mysql' '--with-zlib' '--with-openssl=/usr/local/ssl' '--with-mnogosearch=/usr/local/mnogosearch' '--enable-sigchild' '--enable-inline-optimization' '--with-jpeg-dir=/usr/lib' '--with-png-dir=/usr/lib' '--with-tiff-dir=/usr/lib' '--with-pear' '--with-gd' '--with-iconv' '--with-imap'