PHP-DB - Problems with DB2

I only have two months with PHP. I am trying to access a DB database with ODBC but I have a problem and haven't found the solution in the Internet. My code is:


I get the connection and the statement, but I get an exception getting the result.

If you can give me code to execute a select statement, that would help me too. I haven't been able to do it with what i have searched and i settled for ODBC>

Your help would be greatly appreciated.

[QUOTE=handro1104]I only have two months with PHP. I am This code fails too:


The sql works fine with DbVisualizer.

The actual problem is that I am getting false for $result.

$dbconn = odbc_connect("xxxx", "xxxx", "xxxx");
$sql ="select name, local_name from factory.attachments where name like '%7142930%UNCLASSIFIED.xml' FETCH FIRST 2 ROWS ONLY;";
$result = odbc_exec($dbconn, $sql);
while (odbc_fetch_row($result)) {
$fileName = odbc_result($result, 'Name');
echo "$fileName<br/>";
}