Re: PHP & PostgreSQL

Boget, Chris wrote:
<blockquote type="cite"
 cite="mid4040BBE81A9AD411BD27009027887A7C0431BF@tiger.wild.net">

  <meta name="Generator"
 content="MS Exchange Server version 5.5.2650.12">
  PHP & PostgreSQL
  I'm switching from a MySQL environment to PGSQL and
I'm
  going through and trying to learn the differences
between the
  two.  I've come across some issues that I can't seem
to find the
  answers to in the docs or on the web.  I'm hoping
someone can
  help me out.

I'll try.
<blockquote type="cite"
 cite="mid4040BBE81A9AD411BD27009027887A7C0431BF@tiger.wild.net">

  * MySQL has a function to reset the result set so
that it can be
  iterated through again - mysql_data_seek().  I don't
see that there
  is a similar function for PGSQL.  Is that true?  If
so, in order to
  reset the result set you have to perform the query
again?  Isn't
  that a waste of resources?

In the PGSQL fetch functions, you usualy pass the row number
as a parameter. So you can iterate through the table as many times
as you want, just create a counter to control the iteration.
<blockquote type="cite"
 cite="mid4040BBE81A9AD411BD27009027887A7C0431BF@tiger.wild.net">
  * For PGSQL, you can get the database name, the
field name
  even the *host name* but you can't get the table name
from a
  particular query?

I'm afraid that's true, at least I don't know such a function.

But I advise you to try the PEAR DB extension from PHP,
instead of using directly the database functions.

my regards,

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br