<?
//-------PHP + Access 数据库的使用--------
$c . realpath("data.mdb"); 
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
$sql="select * from test";
$result=odbc_exec($connid,$sql);
if($result) 
{
$colName = odbc_num_fields($result);
echo "\n";
for ($j=1; $j<= $colName; $j++)
{
echo "";
}
$j=$j-1;
$c=0;
// end of field names
while(odbc_fetch_row($result)) // getting data
{
$c=$c+1;
if ( $c%2 == 0 ) 
echo "\n";
else 
echo "\n";
    for($i=1;$i<=odbc_num_fields($result);$i++)
      {        
        echo "";        
        if ( $i%$j == 0 )  
            {
           $nrows+=1; // counting no of rows    
         }  
      }
    echo "";
   
}
echo "\n";
echo "
  ";
echo odbc_field_name ($result, $j );
echo " 
";
        echo odbc_result($result,$i);
        echo "
 
\n";

}
else echo "failed";
?>