[RESOLVED] oracle func php

devostash

I am very new to using php with oracle. I know how to pull in rows from mysql and use them but can't seem to get it working in oracle.

Can anyone help below is my code.

ociexecute($correct);

while ($crows = ocifetchstatement($correct, $res, "0", "-1", OCI_FETCHSTATEMENT_BY_ROW+OCI_NUM)) {
echo "<tr>" ;
echo "<td> $res[0] . </td>";
echo "<td>. $res[1] .</td>";
echo "<td>. $res[2] .</td>";
echo "</tr>";

I know the $corre ct sql works as I have tried it in the db I am connecting to.
Thanks
devo

NogDog

$res will be a mutli-dimension array where the first array index is the result row, so I think you'd do something like:

$crows = ocifetchstatement($correct, $res, "0", "-1", OCI_FETCHSTATEMENT_BY_ROW+OCI_NUM)
if($crows)
{
   foreach($res as $row)
   {
      echo "<tr>";
      echo "<td> $row[0] . </td>";
      echo "<td>. $row[1] .</td>";
      echo "<td>. $row[2] .</td>";
      echo "</tr>";
   }
}
else
{
   // now rows returned
}

devostash

Thanks for your help...

My problem was me being totally dumb with a capital DUMB.....
I was running my php page against my test db so was getting diif results resulting in no rows.
My sql I check I checked in the live db..
I will now go and bang my head against a very hard wall repeatedly...
Thanks again for your help.