Use Table from Other DB?

[dannygoor]

I have to MySQL databases, DB1 and DB2,
DB1 is a myspace type database, DB2 is a shopping cart.

users can access the shopping cart thru their page, however, being that they are different DB's users have to recreate all their information.

I was wondering if there was a way for DB2 to get all the user information from DB1?

thanks

[Dan Grossman]

users can access the shopping cart thru their page, however, being that they are different DB's users have to recreate all their information.

I was wondering if there was a way for DB2 to get all the user information from DB1?

You want your shopping cart application to get user information from your myspace database. That's perfectly doable (anything is doable!), but you're probably going to have to do some recoding to not only involve the second database, but rework the information into whatever format the cart expects.

[dannygoor]

ok, how do I do this?

[Dan Grossman]

How do you... recode an application to work differently? I'd suggest hiring a programmer.

[r937]

both apps should have a login process

all you need to modify is one of those processes to do its userid lookup in the other database

very doable

[dannygoor]

can you recommend a script or something?