I swear there's a dirt simple function/solution; however, I am suffering from a mindflayer moment. Beyond looping through the results here's my sad monday morning attempt:

PHP Code:

   ob_start();
   odbc_result_all($rs); // ## rs = Resultset
   $out = ob_get_contents();
   ob_end_clean();

   $lard = array("<table><tr><th>","<tr><td>","</th></tr>","</td></tr>","</table>");
   $meat = array("</th><th>","</td><td>");

   $out = str_replace($lard, "", $out); // ## trim the fat
   $out = str_replace($meat, ",", $out); // ## carve the meat 


Why not just use odbc_result and format the output however you want?

My (poor?) Reasoning:

1. Looping through using odbc_result seems to take longer in my testing (small scale - using the following method):

PHP Code:

 $out = null;
 while ($row = odbc_fetch_row($rs))
  {
   foreach(range(1,odbc_num_fields($rs)) as $i) {$out .= odbc_result($rs,$i).",";}
   $out = substr($out,0,-1)."\n";
  } 


2. I only recently stumbled across the function odbc_result_all and subsequently felt like a... fool for looping through the recordset in order to (essentially) do the same thing in countless scripts/apps to date.

3. Given the popularity of delimited based import/export and the existence of the aforementioned function (odbc_result_all) I naturally assumed that I just missed a similar function with similar purpose. Perhaps: odbc_result_csv? or the like.

So after a bit of thought (for a change), caffine, and your (Nullpointer) response, i'm thinking this might be a better solution:

PHP Code:

 $out = null;
 while($row = odbc_fetch_array($rs))
  {
   $out .= implode(",",$row)."\n";
  } 


Thoughts?