SitePoint Sponsor |
|
User Tag List
Results 1 to 6 of 6
Thread: Use Table from Other DB?
-
Jun 5, 2007, 14:19 #1
- Join Date
- Jan 2004
- Location
- california
- Posts
- 7
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Use Table from Other DB?
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
-
Jun 5, 2007, 14:58 #2
- Join Date
- Aug 2000
- Location
- Philadephia, PA
- Posts
- 20,578
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
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.
Try Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more
-
Jun 5, 2007, 15:51 #3
- Join Date
- Jan 2004
- Location
- california
- Posts
- 7
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
ok, how do I do this?
-
Jun 5, 2007, 16:00 #4
- Join Date
- Aug 2000
- Location
- Philadephia, PA
- Posts
- 20,578
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
How do you... recode an application to work differently? I'd suggest hiring a programmer.
Try Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more
-
Jun 5, 2007, 16:05 #5
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
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
-
Jun 5, 2007, 16:26 #6
- Join Date
- Jan 2004
- Location
- california
- Posts
- 7
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
can you recommend a script or something?
Bookmarks