using multiple databases

[Woodburn2006 0]

i am trying to display info on a single page from multiple databases but the first sql query is fine as i have selected the first db to use. but i use the mysql_select_db() function to select the next DB but it still tries to connect to the first DB and ignores the fact that i have tried to select a new DB. is there any way i can do this?

[maxic0 0]

Put mysql_close() at the end of the first piece.
Then connect again.

[Woodburn2006 0]

cool thanks, sorted now