2 Replies Latest reply: Apr 26, 2012 8:22 AM by adoniascl RSS

    Looping multi DBs like PHP

      Hello Friends.


      I have 2 DBs (CLIENTS, RENT), with two different ODBC connections.


      When I try to connect in PHP do the following way:

       

       

       

       

      PHP  SINT

      //FIRST ODBC CONECTIONS

      NEW() ODBC1;

      ODBC1->QUERY("SELECT * FROM CLIENTS.ACTIVES");

       

      while( $A = ODBC->FETCHARRAY()){

       

           //SECOND ODBC CONECTIONS

           NEW() ODBC2;

           ODBC2->QUERY("SELECT * FROM RENT.DEBTOR WHERE CLIENT_ID = '".$A[ID]."' ");

       

           BLA BLA BLA

       

      }


      PRINT CLIENTS ACTIVES AND RENT DEBTOR....

       

       

      I can do something similar in QlikView?