Re: Re: Bad column offset?

Hi Paulo!

In your query you have the following select:

>       $result = pg_exec( $pgconn, "select htl.nom_htl from htl where
> htl.des_det_htl='s'" ) or die("Query formatted wrong!");

Everything goes well until you try:

>         $temp = pg_result($result, $i, "htl.nom_htl");
>
> Warning: Bad column offset specified in
> /usr/local/etc/httpd/htdocs/myscript.php3 on line 21

Even though you have requested the column "htl.nom_htl" from the table "htl", an error is generated since the column
labelreturned 
by postgres is simply "nom_htl", hence the bad column offset (label, in this case)! Of course you can change this label
byusing an 
alias. Try replacing the label in the "pg_result" by:

        $temp = pg_result($result, $i, "nom_htl");

This should work. Bye, Mauricio

--
Mauricio Carvalho de Oliveira
mailto:carvalho@dt.fee.unicamp.br
http://www.dt.fee.unicamp.br/~carvalho