Jump to content


Photo

using multiple databases


  • Please log in to reply
2 replies to this topic

#1 Woodburn2006

Woodburn2006
  • Members
  • PipPipPip
  • Advanced Member
  • 214 posts

Posted 09 September 2006 - 08:37 PM

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?

#2 maxic0

maxic0
  • Members
  • PipPipPip
  • Advanced Member
  • 70 posts

Posted 09 September 2006 - 08:58 PM

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

#3 Woodburn2006

Woodburn2006
  • Members
  • PipPipPip
  • Advanced Member
  • 214 posts

Posted 09 September 2006 - 09:20 PM

cool thanks, sorted now




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users