Hi all!
I have a mdb db, which I can access through odbc via php, but I can only make sql sentences like select * from mytable.
If I add a WHERE clause or something else, I get a blank page.
I have created a simple index.php with this code:
<?php
if ($conn_access = odbc_connect ( "gestoria", "", "",SQL_CUR_USE_ODBC))
{
echo "Conectado correctamente" . "<BR>";
$ssql = "select * from expedientes where numero_expediente=1";
echo "<BR>" . $ssql . "<BR>";
if($rs_access = odbc_exec ($conn_access, $ssql)){
echo odbc_num_rows($rs_access);
echo "sql sentence succesfull";
while ($fila = odbc_fetch_object($rs_access)){
$fila = odbc_fetch_object($rs_access);
echo "<br>" . $fila->numero_expediente;
}
}else{
echo "error trying to execute SQL";
}
} else{
echo "Error conexion with db";
}
?>
any help please?
10x in advance