Re: [PHP] multiple databases with one connection

2005-04-11 Thread Richard Lynch
On Sun, April 10, 2005 9:55 pm, Yulius Tjahjadi said: > Is there a way to change the database after a pg_connect > happens? I think in mysql, you can do mysql_select_db('newdb'), > but there isn't really an equivalent function. > > In psql, I can use \connect "newdb", but I think that disconnect >

Re: [PHP] multiple databases

2003-07-15 Thread Jeff Harris
On Jul 16, 2003, "Paulo Neves" claimed that: |Hi, | |How can I set up PHP to work with multiple databases in the same page? |(not tables) | |That's all, | |Thanks | |PN | How do you work with multiple variables in the same page? query("INSERT INTO useronline VALUES (3, 4, 'Joe Momma'"); ?> The

Re: [PHP] multiple databases

2003-07-15 Thread Curt Zirzow
Paulo Neves <[EMAIL PROTECTED]> wrote: > Hi, > > > > How can I set up PHP to work with multiple databases in the same page? > (not tables) $dbh1 = server_connect(params...); $dbh2 = server_connect(params...); Just be sure to pass the optional $dbh1 or $dbh2 to the appropriate query. $result

[PHP] multiple databases

2003-07-15 Thread Paulo Neves
Hi, How can I set up PHP to work with multiple databases in the same page? (not tables) That's all, Thanks PN

Re: [PHP] multiple databases

2001-02-28 Thread Christian Reiniger
On Wednesday 28 February 2001 09:42, you wrote: > Is it a wise idea to have a PHP web application running on multiple > databases? Everything I've done to date has run off one database, no If you get *really much* traffic, it's wise to split things up to 2 or 3 databases (each on a dedicated ma

Re: [PHP] multiple databases

2001-02-28 Thread Simon Garner
From: "Michael Hall" <[EMAIL PROTECTED]> > > > Do you mean 10 different database servers, or 10 databases on the one > > server? > > 10 databases on the one server. > > > As far as I know, separate databases on the one server give the same > > performance as separate tables in one database. > > M

Re: [PHP] multiple databases

2001-02-28 Thread Michael Hall
> Do you mean 10 different database servers, or 10 databases on the one > server? 10 databases on the one server. > As far as I know, separate databases on the one server give the same > performance as separate tables in one database. Music to my ears. > With separate database servers you wil

Re: [PHP] multiple databases

2001-02-28 Thread Simon Garner
From: "Michael Hall" <[EMAIL PROTECTED]> > I'd like to run this past anyone who'd care to comment before I get too > far down the track I'm considering taking with a PHP web portal site. > > Is it a wise idea to have a PHP web application running on multiple > databases? Everything I've done to d

[PHP] multiple databases

2001-02-28 Thread Michael Hall
I'd like to run this past anyone who'd care to comment before I get too far down the track I'm considering taking with a PHP web portal site. Is it a wise idea to have a PHP web application running on multiple databases? Everything I've done to date has run off one database, no matter how large i