Welcome Guest, Not a member yet? Register   Sign In
Getting same info with diferent queries
#10

[eluser]tjmthome[/eluser]
To your 1st. observation Derek, when i print out $this->db->last_query() after each query, it displays correctly.

Also the file oci8_driver.php already has the change as noted kgill
here

I made queries by hand and there is no problem; the info displays correctly
Code:
<?php
    $qryUsrs ='select * from users';
    $qryDocs='select * from documents';
    $cnx = @oci_connect('myusrname', 'mypass', '//172.21.9.7:1525/admsfa');
    $sent = oci_parse($cnx, $qryUsrs);
    $sent2 = oci_parse($cnx, $qryDocs);
    oci_execute($sent);
    oci_execute($sent2);
    echo '<table>';
    while ($row = oci_fetch_array($sent, OCI_RETURN_NULLS)){?&gt;
        <tr>
        <td>&lt;?= $row[0] ?&gt;</td>
        <td>&lt;?= $row[1] ?&gt;</td>
        <td>&lt;?= $row[2] ?&gt;</td>
        </tr>&lt;?php
    }
    echo '</table><br /><hr />';
    // the 2dn qry
    echo '<table><tr>';
    while ($row = oci_fetch_array($sent2, OCI_RETURN_NULLS)){?&gt;
        <td>&lt;?= $row[0] ?&gt;</td>
        <td>&lt;?= $row[1] ?&gt;</td>
        <td>&lt;?= $row[2] ?&gt;</td>
        </tr>&lt;?php}
    echo '</table>';
?&gt;

I want to point out that this is a existing application wich we're migrating, to CI

thanks again for help supplied.


Messages In This Thread
Getting same info with diferent queries - by El Forum - 06-09-2008, 10:21 AM
Getting same info with diferent queries - by El Forum - 06-09-2008, 11:45 AM
Getting same info with diferent queries - by El Forum - 06-09-2008, 03:24 PM
Getting same info with diferent queries - by El Forum - 06-09-2008, 06:04 PM
Getting same info with diferent queries - by El Forum - 06-10-2008, 10:44 AM
Getting same info with diferent queries - by El Forum - 06-10-2008, 12:48 PM
Getting same info with diferent queries - by El Forum - 06-11-2008, 10:17 AM
Getting same info with diferent queries - by El Forum - 06-11-2008, 10:20 AM
Getting same info with diferent queries - by El Forum - 06-11-2008, 03:27 PM
Getting same info with diferent queries - by El Forum - 06-11-2008, 03:57 PM
Getting same info with diferent queries - by El Forum - 06-12-2008, 05:17 AM
Getting same info with diferent queries - by El Forum - 06-12-2008, 10:46 AM
Getting same info with diferent queries - by El Forum - 06-13-2008, 02:11 PM



Theme © iAndrew 2016 - Forum software by © MyBB