Select in Oracle 10g doubles output

[nst]

The code below connects to an Oracle 10g database, but it produces twice the output of every table

<?php

    // CONNECT to the database
$conn = oci_connect('stocks', 'stocks');
if (!$conn) {
    $e = oci_error();
    print htmlentities($e['message']);
exit;
}

    // SELECT and output on the screen
$query = 'SELECT * FROM STOCKS';
$stid = oci_parse($conn, $query);
if (!$stid) {
    $e = oci_error($conn);
    print htmlentities($e['message']);
    exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if (!$r) {
    $e = oci_error($stid);
    echo htmlentities($e['message']);
    exit;
}
print '<table border="1">';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
    print '<tr>';
    foreach ($row as $item) {
        print '<td>'.($item?htmlentities($item):'&nbsp;').'</td>';
    }
    print '</tr>';
}
print '</table>';

oci_close($conn);
?>

Output

T100_S T100_S
T101_S T101_S
T102_S T102_S

although it should be

T100_S
T101_S
T102_S

[Fumigator]

You're telling it to:

print '<td>'.($item?htmlentities($item):'&nbsp;').'</td>'; 

[raf]

he uses the

$item?htmlentities($item):' ' 

as shorthand for

if ($item){
 echo htmlentities($item);
}else{
  echo ' ';
} 

so that should be correct.

[Fumigator]

Whoops sorry that's me not quite awake...

[nst]

Correct. Also a simple echo didn't help. Why?

while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
    print '<tr>';
    foreach ($row as $item) {
        echo $item;
    }
    print '</tr>';
}
print '</table>'; 

Of course a direct query to the database does not produce the error.

Maybe it has to do with the Predefined Constants like 'OCI_DEFAULT'

Any idea what exactly these are?

[Fumigator]

OK maybe this answer will be a little more thought out and intelligent.

You are looping through every index in the array created by oci_fetch_array(). the function oci_fetch_array() creates both a numeric index and an associative index, so you are getting two indices with the same value in the loop.

Use oci_fetch_row() or oci_fetch_assoc() to limit the number of indices to one per row.

[nst]

Fumigator, it's ovbious you are awake now... It worked!

Actually, output is equal correct with either one of the following

while ($row = oci_fetch_row($stid)) { 

while ($row = oci_fetch_assoc($stid)) { 

Thank you.