Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    13

    Unanswered: Data from multiple DB's

    Guys, I have an assignment question here... I'm not asking for code or anything, but rather some light shed on this very vague requirement...

    We have been asked to setup a retrieval system, using ASP.NET or PHP to retrieve contents from "multiple" databases. The content should be of all different formats.

    Any idea's/

  2. #2
    Join Date
    Mar 2008
    Posts
    11
    In your queries, just put the database name in front of the table name. For example:

    $query=mysql_query("SELECT * FROM DATABASE1.TABLE1");

    Quote Originally Posted by wishwashed
    The content should be of all different formats.
    What do you mean by that?
    Website Hacks
    Programming/computer help

  3. #3
    Join Date
    Nov 2007
    Posts
    13
    I need to access mutiple database, not multiple tables.

    And multi-format including a text db, an image db and possibly an audio db. Eac DB storing and handling different media formats... You know.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    4 part naming
    server.database.schema.object

    Or separate connection objects using different connection strings (see www.connectionstrings.com)
    George
    Home | Blog

Posting Permissions

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