<html>
<body>
PHP Example -- glmaster dump<P>
<?php
$cn=odbc_connect('gl001','gl001','11111');
echo "<p>connection opened OK<p>";
$sql="SELECT * FROM glmaster";
echo "<p>SQL string=";
echo $sql;
echo "<p>";
$rs=odbc_exec($cn,$sql);
echo "<p>rs opened OK<p>";
echo "<table border='1'><tr>";
echo "<td>Major</td>";
echo "<td>Minor</td>";
echo "<td>Sub1</td>";
echo "<td>Sub2</td>";
echo "<td>Account Description</td>";
echo "<td>Balance</td></tr>";
$row_count=0;
while (odbc_fetch_row($rs))
{
$row_count=$row_count+1;
$maj=odbc_result($rs,"major");
$min=odbc_result($rs,"minor");
$s1=odbc_result($rs,"sub1");
$s2=odbc_result($rs,"sub2");
$ad=odbc_result($rs,"acctdesc");
$bal=odbc_result($rs,"balance");
echo "<tr><td>" . $maj . "</td>";
echo "<td>" .$min . "</td>";
echo "<td>" .$s1 . "</td>";
echo "<td>" .$s2 . "</td>";
echo "<td>" .$ad . "</td>";
echo "<td>" .$bal . "</td>";
echo "</tr>";
}
odbc_close($cn);
echo "</table>";
echo "<p>Row Count = ".$row_count;
echo "<p>Normal Termination -- ";
echo date("D g:i:s A F d, Y",time());
?>
</body>
</html>