<?php

//create an instance of the  ADO connection object
$conn = new COM ("ADODB.Connection")
  or die("Cannot start ADO");

//define connection string, specify database driver
$connStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\wamp\\www\\test1\\database\\directorydb.mdb";
  $conn->open($connStr); //Open the connection to the database

//declare the SQL statement that will query the database
$query = "SELECT Category FROM tblCategories";

//execute the SQL statement and return records
$rs = $conn->execute($query);

$num_columns = $rs->Fields->Count();
echo $num_columns . "<br>";

for ($i=0; $i < $num_columns; $i++) {
    $fld[$i] = $rs->Fields($i);
}

echo "<table>";

while (!$rs->EOF)  //carry on looping through while there are records
{
    echo "<tr>";
    for ($i=0; $i < $num_columns; $i++) {
        echo "<td>" . $fld[$i]->value . "</td>";
    }
    echo "</tr>";
    $rs->MoveNext(); //move on to the next record
}


echo "</table>";

//close the connection and recordset objects freeing up resources
$rs->Close();
$conn->Close();

$rs = null;
$conn = null;
?>

<?php include('inc_dbconn.php');?>
<?php
//declare the SQL statement that will query the database
$query = "SELECT * FROM tblCategories";
//execute the SQL statement and return records
$rs = $conn->execute($query);
$num_columns = $rs->Fields->Count();

             <?php
                $i=2;
                $count=2;
                while (!$rs->EOF)
                {
                ?>
                <tr>
                  <td><?php $fld[$i] = $rs->Fields("Category"); echo $fld[$i]->value;$rs->MoveNext(); ?></td>
                  <td><?php $fld[$i] = $rs->Fields("Category"); echo $fld[$i]->value;$rs->MoveNext(); ?></td>
                  <td><?php $fld[$i] = $rs->Fields("Category"); echo $fld[$i]->value;$rs->MoveNext(); ?></td>
                </tr>


                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <?php
                }
                ?>
              </table>