<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="description" CONTENT="Insert page description here">
<META NAME="keywords" CONTENT="Insert page keywords here">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-1">
<TITLE>Page Title</TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function LoadPage()
{
//timevalue=setTimeout("document.CustInfoForm.submit()", 2000);
}
//-->
</SCRIPT>
</HEAD>
<BODY bgcolor="black" text="white" onload="LoadPage()">
<!-- BODY bgcolor="black" text="white" //->
PHP
<br>
<?php
$cnx = odbc_connect( 'northwind', '', '' );
$cur = odbc_exec( $cnx, 'SELECT customerid,companyname,contactname,city,phone,fax FROM Customers' );
?>
<TABLE border=1>
<TR>
<TH>customerid</TH>
<TH>companyname</TH>
<TH>contactname</TH>
<TH>city</TH>
<TH>phone</TH>
<TH>fax</TH>
</TR>
<?php while( odbc_fetch_row( $cur ) )
{
$custID = odbc_result( $cur, "customerid" );
$comName = odbc_result( $cur, "companyname" );
$conName = odbc_result( $cur, "contactname" );
$city = odbc_result( $cur, "city" );
$phone = odbc_result( $cur, "phone" );
$fax = odbc_result( $cur, "fax" );
echo "<TR><TD>$custID</TD><TD>$comName</TD>".
"<TD>$conName</TD><TD>$city</TD><TD>$phone</TD>".
"<TD>$fax</TD></TR>\n";
}
odbc_close( $cnx );
?>
</TABLE>
<form method="post" name="CustInfoForm" action="northwind.php">
<input type="submit" value = "rerun">
</form>
</BODY>
</HTML>