Re: oracle: fetch a query result into an array

To make your life much easier, I recommend using PEAR DB. The function calls are very easy and work for any DBMS (no remembering DB specific calls :-)). It also gives you lots of added functionality, such as fetching of an entire result set at once, fetching only one row, or even fetching one column quickly and without the need to worry about freeing your resources. Used right, you don't have to worry about memory leaks or even the DB backend you're using. http://pear.php.net/package/DB http://pear.php.net/manual/en/package.database.php Torsten Lange wrote:

Hello, I'm a php beginner and not succeed in fetching an oracle query result into an array. I want to load the colum names of a table (from an Oracle9i) into a <select>-field. There is something working, but only the last column name appears in the select field and is wraped by each letter. For instense acw_fid_lab: ___ |non| |all| |A | |C | . . and so on. What are my mistakes? If anyone could suggest me how to solve it or using a better approach... Thank you, Torsten --------------------------------------------------- My last version (I also tried OCIFetchInto before): --------------------------------------------------- function fill_select($table_name) { $connect = @OCILogon("", "", ""); if(!$connect)

      {
      $err_oci = OCIError();
      echo "(2) No connection - OCIError():    ".$err_oci["message"];
      echo "<p>";
      }
      else
         {
         $sql_table_names = "SELECT column_name FROM user_tab_columns
                             WHERE table_name = '".$table_name."'";
         $stmt = OCIParse($connect, $sql_table_names);
         OCIExecute($stmt);

         $column_name = array();
         $counter = 0;

         while(OCIFetch($stmt))
            {
            $column_name = OCIResult($stmt,'COLUMN_NAME');
            $counter++;
            }

         if($counter == 0)
            {
            $column_name[0] = "nothing found";
            }
         OCIFreeStatement($stmt);
         OCILogOff($connect);
         return($column_name);

         }

} # This is a cut-out from that file I call the function from echo " <td>\n";

echo "       <select name=\"chemistry\" size=\"12\" multiple>\n";
echo "       <option>none</option>\n";
echo "       <option>all</option>\n";
             $table_name = "AN_CHEMISTRY_WATER";
             $count = (int) count_table_columns($table_name);
             $column_names = fill_select($table_name);
             for($i=1; $i<=$count; $i++)
                {
                 echo "<option>",$column_names[$i],"</option>\n";
                }
echo "       </select>\n";

echo " </td>\n";

-- -- paperCrane <Justin Patrin>