X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0ECC4D1DD11 for ; Tue, 2 Mar 2004 00:34:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 65028-01 for ; Mon, 1 Mar 2004 20:34:31 -0400 (AST) Received: from Ariel2.idahopower.com (unknown [204.76.195.72]) by svr1.postgresql.org (Postfix) with SMTP id 291C0D1DD0C for ; Mon, 1 Mar 2004 20:34:28 -0400 (AST) Received: from 204.76.195.33 by Ariel2.idahopower.com with ESMTP (IPCo Mail Relay at your service (MMS v4.7);); Mon, 01 Mar 2004 17:28:03 -0700 X-Server-Uuid: c4da1ae6-7048-11d2-bc8e-00a083360239 Received: from bedford.idacorp.local ([172.18.201.66]) by midway.idacorp.local with Microsoft SMTPSVC(5.0.2195.6713); Mon, 1 Mar 2004 17:34:28 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Re: pg_fetch_row Problem Date: Mon, 1 Mar 2004 17:34:26 -0700 Message-ID: <71B8A8BEC516CF46835CA629156CF21163F7FD@bedford.idacorp.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PHP] pg_fetch_row Problem Thread-Index: AcP/687pS0ShPThAQxWYOQc0hnEZLQAAhweA From: "Seader, Cameron" To: "Chris Smith" , pgsql-php@postgresql.org X-OriginalArrivalTime: 02 Mar 2004 00:34:28.0138 (UTC) FILETIME=[1ED990A0:01C3FFEE] X-WSS-ID: 6C5D0A981077211-12-01 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/13 X-Sequence-Number: 2612 Chris, I tryed this out and it works great thanks, but now i get this message. Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html= /PMS/csv_export.php on line 41 Know where i can set execution times? is this for PHP or PostgreSQL? Thanks, Cameron -----Original Message----- From: Chris Smith [mailto:chris@interspire.com] Sent: Monday, March 01, 2004 5:17 PM To: Seader, Cameron; pgsql-php@postgresql.org Subject: RE: [PHP] pg_fetch_row Problem Hi Cameron, I think the reason is you're going beyond the number of results you have for that query. Rewrite the while(...) loop to look like this: $result_count =3D 0; while($result_count < $count) { $row =3D pg_fetch_row($result, $result_count); ......... } See if that works. Chris. -----Original Message----- From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Seader, Cameron Sent: Tuesday, March 02, 2004 10:50 AM To: pgsql-php@postgresql.org Subject: [PHP] pg_fetch_row Problem Greetings, I am not sure what is going on with my script here, but i am getting this error when i run it. Warning: pg_fetch_row(): Unable to jump to row 706 on PostgreSQL result index 3. in /var/www/html/PMS/csv_export.php on line 32 Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/PMS/csv_export.php:4) in /var/www/html/PMS/csv_export.php on line 59 Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/PMS/csv_export.php:4) in /var/www/html/PMS/csv_export.php on line 62 Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/PMS/csv_export.php:4) in /var/www/html/PMS/csv_export.php on line 63 Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/PMS/csv_export.php:4) in /var/www/html/PMS/csv_export.php on line 64 Can anyone tell me what is going on here??????? I am including my script here below so you can see what it is doing, maybe you all can see something im not: Any Help would be appreciated. Thanks, Cameron Seader mailto:CSeader@Idahopower.com 1.208.388.2582 Office [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential = and/or exempt from disclosure under applicable law. If you are not the int= ended recipient, you are hereby notified that any disclosure, copying, dist= ribution, or use of the information contained herein (including any relianc= e thereon) is STRICTLY PROHIBITED. If you received this transmission in err= or, please immediately contact the sender and destroy the material in its e= ntirety, whether in electronic or hard copy format. Thank you. A2