Received: from hub.org (hub.org [216.126.84.1]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UIeMC45463 for ; Mon, 30 Oct 2000 13:40:22 -0500 (EST) (envelope-from pgsql-interfaces-owner@mail.postgresql.org) Received: from bush.rutgersinsurance.com (IDENT:root@rutgersinsurance.com [38.138.71.194]) by hub.org (8.10.1/8.11.0) with ESMTP id e9UIdWi50348 for ; Mon, 30 Oct 2000 13:39:32 -0500 (EST) (envelope-from aalang@rutgersinsurance.com) Received: from 6014cwpza006 ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id NAA00514; Mon, 30 Oct 2000 13:44:49 -0500 Message-ID: <012101c042a1$18928fc0$330a0a0a@6014cwpza006> From: "Adam Lang" To: "Rich.Martin" , References: Subject: Re: web interface php3 question. Date: Mon, 30 Oct 2000 13:42:03 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200010/11 X-Sequence-Number: 11 It should work with version 3. Are there 7 rows of data in the table? It might not let you call it if the row doesn't exist. http://php.net/manual/function.pg-fetch-array.php Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Rich.Martin" To: Sent: Monday, October 30, 2000 1:19 PM Subject: [INTERFACES] web interface php3 question. > Hello, > I'm trying to setup a web page that calls a PostgreSQL database. I'm > connecting to the database ok. Does anyone know if php3 support > pg_fetch_array? I keep getting an error that says: > > Warning: Wrong parameter count for pg_fetch_array() in > /home/contacts/whole.phtml on line 72 > > I'm calling it in the code like this: > > while ($r = pg_fetch_array($result)) {$company = $r["company']; > > if I add a another variable like this: > > while ($r = pg_fetch_array($result, 7)) {$company = $r["company']; > > the resulting page takes forever to load and repeats the first entry to the > database. I know that the server I'm using has php3 on it. Is that the > problem? > > If you have a solution please let me know. > Thanks, > Rich