SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Member
    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

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by dannygoor View Post
    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.

  3. #3
    SitePoint Member
    Join Date
    Jan 2004
    Location
    california
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok, how do I do this?

  4. #4
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    How do you... recode an application to work differently? I'd suggest hiring a programmer.

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 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
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Member
    Join Date
    Jan 2004
    Location
    california
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    can you recommend a script or something?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •