Fetching data with ODBC failed with empty result in PHP?

See more:

PHP

I connected and executed query without throwing any exception. But I tried fetching rows to display the data in a table and an exception was thrown at my foreach.
Here is my code:

$con = odbc_connect("My DSN","","");
$result = odbc_exec($con,"My query");
if($result)
{
  echo "<table align=center>";
  while($row=odbc_fetch_array($result))
  {
    echo "<tr>";
    foreach($row as $r)
       echo "<td>$r</td>";
    echo "</tr>";
  }
echo "</table>";
odbc_close($con);
}

It said that I used a variable ($row) which couldn't be iterated with foreach.
I have used the above code with mysql, mssql and they worked fine but odbc gave me that error, please remember that I connected and queried successfully, it reported the error line at the foreach statement as I said, it was so strange, and I have tried with odbc_result to fetch only 1 cell, it didn't throw exception but the result was empty.
Could you please give me some reason elaborating on this?
Any of your help would be appreciated!
Thanks!