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 and

[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

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. $result1 =

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? ? $database1_link = mysql_connect('localhost', 'user', 'password');

[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

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 date

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 will

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. Music to my

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