Duplication of Records

[chfarooq]

With this simple query, I am getting a duplicated record of sets. Can any body help me in this regard


<?php
$conn = oci_connect('INKFISH_FAROOQ', 'farooq', '//localhost/XE');
$stid = ociparse($conn, 'SELECT * FROM INKFISH_ADMIN.INKFISH_USER');

$results=ociexecute($stid, OCI_DEFAULT);
print '<table border="1">';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS))
{
$item=null;
foreach ($row as $item) {
echo '<tr><td>'.($item?htmlentities($item):'&nbsp;').' </td></tr>';
}
}
print '</table>';
oci_close($conn);
?>

[ronverdonk]

Do you mean that you have double $items in your table row? The result of statement

[PHP]echo '<tr><td>'.($item?htmlentities($item):'&nbsp;').' </td></tr>';[/PHP]

If so, the first item of the ternary probably is not seen as an expression by PHP.
In that case you could do this

[PHP]echo '<tr><td>'.(!empty($item)?htmlentities($item):'&nb sp;').'</td></tr>';[/PHP]

Hope this works.

Ronald :cool:

[somaskarthic]

hi

I think u have to find the solution in SQL query.
while executing 'select * from table' , it fetches all the data .U have to try
this using primary key value. Since, it is used to avoid duplicates.

somas
---------

With this simple query, I am getting a duplicated record of sets. Can any body help me in this regard


<?php
$conn = oci_connect('INKFISH_FAROOQ', 'farooq', '//localhost/XE');
$stid = ociparse($conn, 'SELECT * FROM INKFISH_ADMIN.INKFISH_USER');

$results=ociexecute($stid, OCI_DEFAULT);
print '<table border="1">';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS))
{
$item=null;
foreach ($row as $item) {
echo '<tr><td>'.($item?htmlentities($item):'&nbsp;').' </td></tr>';
}
}
print '</table>';
oci_close($conn);
?>

[bevort]

Testing the echo(.... command works in both the original way and the included test with !empty(). The last is not nessecary but can be used to make the command more readable.
The ternary conditional operator structure uses the first expression to determen if the second or the third must be used. If a first string is not assign, so NULL, or "" (empty) does not matter. they will return False. If there is a single caracter or more the test will return True and use the second value

So it must be in the database.
I should check your table using a query tools and ask the same query directely to the database. If you have dubbles there they will show upp. Try diffeant sortings also

Vincent

[epuck]

You should add in "OCI_ASSOC" flag

 while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS))

This function was changed because of a php bug. http://bugs.php.net/bug.php?id=37487

gl