Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-23 Thread Zeev Suraski
issue.) Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Markus Fischer [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 6:50 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug

[PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
I believe I may have found a major bug in the use of multiple MySQL connections. Please see my bug report at HYPERLINK http://bugs.php.net/bug.php?id=16730http://bugs.php.net/bug.php?id=167 30. If I’m wrong about this, please tell me how to fix it. This is a showstopper bug for the software I’m

RE: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
] Major Bug in multiple MySQL Connections? I believe I may have found a major bug in the use of multiple MySQL connections. Please see my bug report at HYPERLINK http://bugs.php.net/bug.php?id=16730http://bugs.php.net/bug.php?id=167 30. If I’m wrong about this, please tell me how to fix

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread derick
Hello, this is not a bug, see the details in the bugreport. Derick On Mon, 22 Apr 2002, Matthew Walker wrote: I believe I may have found a major bug in the use of multiple MySQL connections. Please see my bug report at HYPERLINK

RE: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello, this is not a bug, see the details in the bugreport. Derick On Mon, 22 Apr 2002, Matthew Walker wrote: I believe I may have found a major bug in the use of multiple MySQL

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Markus Fischer
Hello Matthew, you should read my commect on this bug report too. 4.2.0 which will be released soon contains already a workaround for this limitation. - Markus On Mon, Apr 22, 2002 at 06:41:44AM -0600, Matthew Walker wrote : I believe I may have found a major bug in the

RE: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
.) Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Markus Fischer [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 6:50 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello Matthew

RE: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello Matthew, you should read my commect on this bug report too. 4.2.0 which will be released soon contains already a workaround for this limitation. - Markus On Mon, Apr 22

RE: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
Software Engineer ePliant Marketing -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 5:53 AM To: Matthew Walker Cc: Markus Fischer; [EMAIL PROTECTED] Subject: RE: [PHP-DEV] Major Bug in multiple MySQL Connections? Just curious, why do you

RE: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
-Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 5:53 AM To: Matthew Walker Cc: Markus Fischer; [EMAIL PROTECTED] Subject: RE: [PHP-DEV] Major Bug in multiple MySQL Connections? Just curious, why do you need multiple identical connections

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Markus Fischer
Senior Software Engineer ePliant Marketing -Original Message- From: Markus Fischer [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 6:50 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
But in this case he wanted to connect twice with the same credentials so that argument makes no sense. -Rasmus On Mon, 22 Apr 2002, Georg Richter wrote: On Monday, 22. April 2002 14:07, Rasmus Lerdorf wrote: But changing the active DB on an open connection is a trivial operation in MySQL.

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
Software Engineer ePliant Marketing -Original Message- From: Markus Fischer [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 6:50 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Markus Fischer
I epected that what we refer to as 'small, self-contained' example, for which most of them don't make sense :p On Mon, Apr 22, 2002 at 05:40:31AM -0700, Rasmus Lerdorf wrote : But in this case he wanted to connect twice with the same credentials so that argument makes no sense.

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Markus Fischer
:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 6:50 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello Matthew, you should read my commect on this bug report too. 4.2.0 which will be released

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
, 2002 6:50 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? Hello Matthew, you should read my commect on this bug report too. 4.2.0 which will be released soon contains already a workaround

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Melvyn Sopacua
At 17:27 22-4-2002, Rasmus Lerdorf shared with all of us: The proper way to do this in your generalized app would be to either force a mysql_select_db on each query to make sure you are talking to the right one, or if you prefer do a select database() query to see which is the current one. ???

Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Daniel Lorch
Hi, No, it doesn't satisfy me at all. Your application design is broken and forcing multiple identical connections doesn't solve it at all. You are trying to associate a selected DB with a database connection artificially. a couple of years ago I was using PHPLIBs db-class and my own

Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
It's not a silly behaviour. Database connections are a very limited resource, much more so than open files, and time after time we saw code that would open up multiple identical connections for no reason whatsoever. This is especially true of large apps that are able to swallow other apps. Like

RE: Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
]: [PHP-DEV] Major Bug in multiple MySQL Connections? It's not a silly behaviour. Database connections are a very limited resource, much more so than open files, and time after time we saw code that would open up multiple identical connections for no reason whatsoever. This is especially true of large

RE: Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
To: Daniel Lorch Cc: Markus Fischer; Matthew Walker; [EMAIL PROTECTED] Subject: Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections? It's not a silly behaviour. Database connections are a very limited resource, much more so than open files, and time after time we saw code that would open up

Re[3]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Daniel Lorch
PROTECTED]] Sent : Montag, 22. April 2002 Subject: [PHP-DEV] Major Bug in multiple MySQL Connections? It's not a silly behaviour. Database connections are a very limited resource, much more so than open files, and time after time we saw code that would open up multiple identical connections

Re[3]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
on and if needed, switch back - transparently to the user? The current implementation only confuses people. -daniel - Original Message - From : Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent : Montag, 22. April 2002 Subject: [PHP-DEV] Major Bug in multiple MySQL Connections

Re: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Markus Fischer
On Mon, Apr 22, 2002 at 07:19:48PM +0200, Melvyn Sopacua wrote : At 17:27 22-4-2002, Rasmus Lerdorf shared with all of us: The proper way to do this in your generalized app would be to either force a mysql_select_db on each query to make sure you are talking to the right one, or if you

RE: Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Steve Meyers
Or use a simple database wrapper, that will save you coding time anyway. Try PHPLIB's wrappers, for example. They handle doing the database select for you, you just have to do the query. Rasmus Lerdorf wrote: So use mysql_db_query() On Mon, 22 Apr 2002, Matthew Walker wrote: Since

RE: Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Matthew Walker
: Re[2]: [PHP-DEV] Major Bug in multiple MySQL Connections? Or use a simple database wrapper, that will save you coding time anyway. Try PHPLIB's wrappers, for example. They handle doing the database select for you, you just have to do the query. Rasmus Lerdorf wrote: So use mysql_db_query

Re: Re[3]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Marc Boeren
this sounds reasonable. But why don't the connection aliases keep the current db they are working on and if needed, switch back - transparently to the user? The current implementation only confuses people. Try dbx, it does exactly that... Cheerio, Mc. -- PHP Development Mailing List

Re[4]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Daniel Lorch
? */ The current DB should be part of the mysql handle. Also the mysql result set (I remember my db-classes to use each others result sets). -daniel - Original Message - From : Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent : Montag, 22. April 2002 Subject: [PHP-DEV] Major Bug in multiple

Re[4]: [PHP-DEV] Major Bug in multiple MySQL Connections?

2002-04-22 Thread Rasmus Lerdorf
db-classes to use each others result sets). -daniel - Original Message - From : Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent : Montag, 22. April 2002 Subject: [PHP-DEV] Major Bug in multiple MySQL Connections? Because the current db is not a property specified