-----BEGIN PGP SIGNED MESSAGE-----
On Sunday 17 November 2002 05:43 pm, you wrote:
> On Fri, 15 Nov 2002, William wrote:
> > I code with PHP and use it to communicate with MySQL, if I started using
> > PostgreSQL would I have to change my coding to communicate with the
> > database?
> Probably, but only slightly.
> I changed my DB from MySQL to PostgreSQL and had to change each SQL call
> slightly. It seems to me the difference was PostgreSQL needs to know the
> number of rows gotten and then loop through them with a for loop, with
> MySQL I was able to use a while loop without checking the number of rows
Using PostgreSQL 7.2 and PHP 4.1.2 in Linux, I found that some code is
becoming similar with the MySQL+PHP. For instance, you don't need to know the
numrows first to do a loop that display a query result.
New PostgreSQL+PHP way:
MySQL way :
You can also use pg_numrows() instead of pg_num_rows() and some other 'new'
syntax that are like mysql way.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
-----END PGP SIGNATURE-----
In response to
pgsql-php by date
|Next:||From: Andy Dunlop||Date: 2002-11-18 07:06:05|
|Subject: Nested select to same tsble|
|Previous:||From: brew||Date: 2002-11-17 10:43:16|
|Subject: Inquiry From Form [pgsql]|