Re: New to OCI - double results?



I got this to work using
while ($row = oci_fetch_row ($stid))

But not I get another problem, see comment here:

$stid = oci_parse($connX, $sql2);
if (!$stid)
{
$e = oci_error($connX);
echo htmlentities($e['message'])."<br>";
}
else
{
$r = oci_execute($stid, OCI_DEFAULT);
// instead of going ahead, it still gives the error here. How do I
stop that.
// the error is correctly catched here anyway, but I'd like to have it
only. Meaning no default response when the query fails.
if(!$r)
{
$e = oci_error($stid);
if(strpos($e['message'],"CONNECT BY loop")!==false)
echo "<font class=\"error\">Loop error with item:
$Item[$i]</font><p>";
else
echo htmlentities($e['message'])."<br>";
}
else
{



On Jan 26, 6:52 pm, "Sonnich" <sonnich.jen...@xxxxxxxxxxxxxx> wrote:
Hello there

I'm trying to work with the example for OCI... and the $row returns 2
values, the same twice, but my query only have one... code below.

Can anyone explain?

BR
S


.