Page 1 of 1

Multople db's, one script.

Posted: Tue Nov 26, 2002 3:37 pm
by Jimbob
Is there any problem with using two or more databases from within a single script, and switching between the db's many times?

What's the best way to switch? using mysql_change_user and mysql_select_db?

Ty,
Jon Crouch.

Posted: Tue Nov 26, 2002 5:29 pm
by mydimension
actually, you can do it right inside your queries:
example:
SELECT * FROM db_name.table_name

Posted: Wed Nov 27, 2002 6:59 pm
by m3mn0n
They both work great, but i suggest the second one. =)