DesignersTalk - View Single Post

greenmop · 28-06-2007, 15:37

Hi,

Does anyone knwo how to do the following easily.

I want to select fields from two tables but each table is on a different database on the same server.

I know how to do this in a stored procedure but mysql version is 3. Stored procedures where not available until version 5.

I am looking to do this in PHP but am not sure if this can be done as you can only connect to one database at a time.

28-06-2007, 15:37	#1 (permalink)
greenmop Registered User Join Date: Mar 2007 Posts: 30	multiple database select in mysql Hi, Does anyone knwo how to do the following easily. I want to select fields from two tables but each table is on a different database on the same server. I know how to do this in a stored procedure but mysql version is 3. Stored procedures where not available until version 5. I am looking to do this in PHP but am not sure if this can be done as you can only connect to one database at a time.