pg_fetch_row Problem - Mailing list pgsql-php

From Seader, Cameron
Subject pg_fetch_row Problem
Date
Msg-id 71B8A8BEC516CF46835CA629156CF21110383A@bedford.idacorp.local
Whole thread Raw
Responses Re: pg_fetch_row Problem  ("Chris Smith" <chris@interspire.com>)
List pgsql-php
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
line32 

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:
<?php
pg_connect("host=172.18.74.10 port=5432 dbname=acquisuite_db user=pgadmin password=pgadmin")
                        or die ( 'Unable to connect to server.' );
                        printf("Connected Successfully");

$MM_param1__panels = ''%'';
if (isset($HTTP_GET_VARS['panel'])) {
  $MM_param1__panels = $HTTP_GET_VARS['panel'];
}
$MM_param2__panels = ''%'';
if (isset($HTTP_GET_VARS['startdate'])) {
  $MM_param2__panels = $HTTP_GET_VARS['startdate'];
}
$MM_param3__panels = ''%'';
if (isset($HTTP_GET_VARS['enddate'])) {
  $MM_param3__panels = $HTTP_GET_VARS['enddate'];
}
$MM_param4__panels = ''%'';
if (isset($HTTP_GET_VARS['order'])) {
  $MM_param4__panels = $HTTP_GET_VARS['order'];
}

$query = sprintf("SELECT * FROM %s WHERE utctime AT TIME ZONE 'MST' BETWEEN '%s' AND '%s' ORDER BY utctime %s",
$MM_param1__panels,$MM_param2__panels,$MM_param3__panels,$MM_param4__panels);

$result = pg_exec($query);
$count = pg_num_fields($result);

for ($i = 0; $i < $count; $i++){
    $header .= pg_fieldname($result,$i)."\t";
}

while($row = pg_fetch_row($result,$result_count++)){
  $line = '';
  foreach($row as $value){
    if(!isset($value) || $value == ""){
      $value = "\t";
    }else{
# important to escape any quotes to preserve them in the data.
      $value = str_replace('"', '""', $value);
# needed to encapsulate data in quotes because some data might be multi line.
# the good news is that numbers remain numbers in Excel even though quoted.
      $value = '"' . $value . '"' . "\t";
    }
    $line .= $value;
  }
  $data .= trim($line)."\n";
}
# this line is needed because returns embedded in the data have "\r"
# and this looks like a "box character" in Excel
  $data = str_replace("\r", "", $data);

# Nice to let someone know that the search came up empty.
# Otherwise only the column name headers will be output to Excel.
if ($data == "") {
  $data = "\nno matching records found\n";
}

# This line will stream the file to the user rather than spray it across the screen
header("Content-type: application/octet-stream");

# replace excelfile.xls with whatever you want the filename to default to
header("Content-Disposition: attachment; filename=excelfile.xls");
header("Pragma: no-cache");
header("Expires: 0");

echo $header."\n".$data;
?>

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
applicablelaw.  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
receivedthis transmission in error, please immediately contact the sender and destroy the material in its entirety,
whetherin electronic or hard copy format.  Thank you.   A2 



pgsql-php by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: get list of databases and tables in Postgres
Next
From: "Chris Smith"
Date:
Subject: Re: pg_fetch_row Problem