Re: [GENERAL] persistent db connections in PHP

2007-06-21 Thread Scott Marlowe
Raymond O'Donnell wrote: [EMAIL PROTECTED] wrote: However, with this new Postgres site, I don't have access to my temp tables after I've traversed another pg_connect. So PHP is either creating a new connection, or giving me another session, not the one which I created my tables in. You wouldn

Re: [GENERAL] persistent db connections in PHP

2007-06-20 Thread Raymond O'Donnell
[EMAIL PROTECTED] wrote: However, with this new Postgres site, I don't have access to my temp tables after I've traversed another pg_connect. So PHP is either creating a new connection, or giving me another session, not the one which I created my tables in. You wouldn't expect to be given back

Re: [GENERAL] persistent db connections in PHP

2007-06-20 Thread Scott Marlowe
[EMAIL PROTECTED] wrote: This seems to be a problem with PHP, or at least my set up. I'm writing pages in basically the same way. Each page has an include at the top that gets you a database session. The function, either pg_connect() or mysql_connect(), is supposed to either create a new connect

Re: [GENERAL] persistent db connections in PHP

2007-06-18 Thread lawpoop
This seems to be a problem with PHP, or at least my set up. I'm writing pages in basically the same way. Each page has an include at the top that gets you a database session. The function, either pg_connect() or mysql_connect(), is supposed to either create a new connection, or return your existin

Re: [GENERAL] persistent db connections in PHP

2007-06-16 Thread PFC
Hello all! I'm working on a PHP site using Postgres as a back-end. I have an include at the top of each page that runs the pg_connect function. I'm implementing some temporary tables, which I understand are destroyed automatically at the end of the session. It seems to me that - Temp t

Re: [GENERAL] persistent db connections in PHP

2007-06-16 Thread Martin Gainty
ginal Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, June 15, 2007 10:52 AM Subject: [GENERAL] persistent db connections in PHP Hello all! I'm working on a PHP site using Postgres as a back-end. I have an include at the top of each page that runs the pg_connect function

[GENERAL] persistent db connections in PHP

2007-06-16 Thread lawpoop
Hello all! I'm working on a PHP site using Postgres as a back-end. I have an include at the top of each page that runs the pg_connect function. I'm implementing some temporary tables, which I understand are destroyed automatically at the end of the session. It seems to me that when I navigate to