Using the ODBC functions Im having problem with simple lines like:
  select max(id) from ident;
  select (name) from main;
But lines like this works fine:
  select id, path, name from main order by path, name;

When Im trying the same lines using the MySQL functions it works fine.

Here is a script that shows my problem:

$dbh = mysql_connect("localhost", $user, $password);
mysql_select_db("vr", $dbh);
$rh = mysql_query("select max(id) from ident;") or die("SQL error");
$t = mysql_fetch_row($rh);
echo "Using MySQL I get id: ". $t[0];
mysql_close($dbh);

$dbh = odbc_connect($dsn, $user, $password);
$rh = odbc_exec($dbh, "select max(id) from ident;") or die("SQL error");
$t = odbc_fetch_row($rh);
echo "Using ODBC I get id: ". $t[0];
odbc_close($dbh);


What is does is it prints out the value it gets from each query. The output I get is:

Using MySQL I get id: 68
Using ODBC I get id:


I can get this to work with perl using DBI and DBI-ODBC so I strongly believes the problem lies in the ODBC implementation in php.

My configure line is like this:
'./configure' '--with-mysql=/usr/local/mysql' '--with-apxs=/usr/local/apache/bin/apxs' '--with-db2' '--disable-debug' '--disable-static' '--enable-sockets' '--with-yp' '--with-zlib' '--with-iodbc=/usr/local/libiodbc-3.0.5'