Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

MySQL: Changing databases in the middle of a script

⇧
0
⇩
36 views

I've never had to do this before, so really I just want to check and see if I'm approaching this the correct way.

I need to switch databases in the middle of a PHP script, and I'm not sure if there are any security issues, or memory issues, or etc...

So I have my connection code at the top of my page.

And in the middle I do the following:

mysql_select_db("new_db") or die(mysql_error());
$query = mysql_query("SELECT * FROM new_db table ORDER BY name ASC");
// Rest of relevant code

Now is there a way to kill this connection afterwards, or do I need to switch back below this part?

php mysql database
asked June 24, 2011 11:18 am CDT
kylex
posted via StackOverflow

1 Answer

⇧
0
⇩
 

Just do a $query = mysql_query("SELECT * FROM new_db.table ORDER BY name ASC");

without having to do a mysql_select_db if it's only for one query

answered June 24, 2011 11:23 am CDT
yes123

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
How to show MySQL databases on a PHP script?
March 8, 2011
Invalid Operator when dumping MySQL databases using script
March 19, 2011
How do document databases deal with changing relationships between objects (or do they at all)?
May 26, 2011
Changing a file upload script to allow a blank file field
January 5, 2011
My MySQL transaction didn't complete, and it's stuck in the middle.
March 9, 2011
MySQL syntax for inserting a new row in middle rows?
June 13, 2011
MYSQL showing all databases even without "show databases" priviledge
March 4, 2011
What to do if user closes page in the middle of a mysql long query?
February 28, 2011
JQuery grab mysql data? or use PHP as a middle man between the database and jquery?
January 16, 2011
Need to insert data in 2 separate databases without exposing the username and password for the databases one to another with PHP.
March 21, 2011
Jsessionid showing up in middle of url
January 6, 2011
Middle Man Server HTTPS/SSL
May 5, 2011
How rare is a man in the middle attack?
May 24, 2011
Strip middle of URL string out with mod_rewrite
June 14, 2011
Regex - URL with a specific beginning and end with something in the middle
April 26, 2011
Sometimes html loading stops at middle
March 22, 2011
Grep with regex in middle of line
April 24, 2011
Regex find something in the middle of the string
April 23, 2011
Oracle script conversion to MySQL 5.0 script
January 4, 2011
RegExp split a string by its middle character matches
June 22, 2011
Regex check for white space in middle of string
April 3, 2011
RegEx How do I match square bracket tags with a pipe in the middle?
February 22, 2011
A proxy that acts as a man-in-the-middle between my tool (which only supports http) and https sites?
January 23, 2011
Changing this from MySQL to MySQLi?
January 9, 2011
Php mysql changing a specifc row
March 21, 2011
Changing the mysql.sock
April 8, 2011
Changing the connection timezone in MySQL
April 1, 2011
Mysql changing values in table?
January 7, 2011
Changing default my.cnf path in mysql
January 8, 2011
MySQL: Changing IDs of primary keys
February 28, 2011