I have a simple SELECT statement that returns more than one row.
When I do something like this:
do
{
.....
} while (OCIFetch($qryResult) != false);
I get an "Out of sequence" error on OCIFetch. So then I tried this:
$numRows = OCIRowCount($qryResult);
for($i = 0; $i < $numRows; $i++)
{
OCIFetch($qryResult);
......
}
Now I get 0, for the row count. If I call OCIFetch once, before the OCIRowCount, I
get a value of 1 (which makes sense I guess, since it will only fetch one row at a
time).
*** How do I step through a SELECT result set?
Thanks
RDB