Oracle + PHP : Display results in HTML Table
<p>I'm having a little trouble tinkering with PHP and Oracle using OCI8 to connect.  I've confirmed that i'm able to connect, but keep getting the below error:</p>

<pre><code>PHP Fatal error: Call to a member function query() on resource ... on line 17.
</code></pre>

<p>Here's the code I have currently</p>

<pre><code>&lt;?php 
$DB = '//DBGOESHERE:PORT/SIDHERE';
$DB_USER = '****';
$DB_PASS = '****';

$conn = oci_connect($DB_USER, $DB_PASS, $DB);

//check for errors
if (!$conn)
{
    $e = oci_error();
    print htmlentities($e['message']);
    exit;
}

$sql = "select display_name, last_export_file, last_export_date from schema.ms_export where last_export_date &gt; sysdate -1 order by last_export_date desc";
$stid = oci_parse($conn, $sql);
oci_execute($stid);
while (oci_fetch($stid)) {
    echo oci_result($stid, 'display_name') . " | ";
    echo oci_result($stid, 'last_export_file') . " | ";
    echo oci_result($stid, 'last_export_date') . "&lt;br&gt;\n";
}
oci_free_statement($stid);
oci_close($conn);
?&gt;
</code></pre>

<p>Any help would be greatly appreciated!  Technically I'm trying to get it to output into a pretty HTML table, but starting with cheap and dirty line breaks.</p>

<p>Thank you!</p>