[phplib] bug report. The active session is saved in the wrong DB From: daniel (daniel <email protected>)
Date: 10/09/00

The problem occurs in the following situation :
  I have a "main_DB" database where I keep the auth_user_md5 and
active_sessions tables.
  Once someone logs in, he is appointed to a specific DB according to
his profile.
  On each page I start with open_page and finish with close_page.
  
  The open_page gets the global variables saved for the session in the
"main_DB" database.
  The I save the data for the user in his "specific" DB.
  The close_page saves the global variable in the same "specific" DB
instead of the "main" DB, even though the db parameters Link_ID ,
Database ... are correct.

  This occurs apparently because mysql_query() sends a query to the
currently active database. In the php documentation, it is written that
mysql_query() sends a query to the currently active database on the
server that's associated with the specified link identifier; but it does
not seem to be the case.

  The solution for mysql that I found is to add in db_mysql.inc, line
115
$choosen_db= <email protected>($this->Database, $this->Link_ID);

Daniel

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>