<? session_start(); ?>

<html>
<head><title>PHP Report<title><head>
<body bgcolor="ffffe0">

<center>

<

  mssql_connect('ServerName', 'Login', 'Password') or DIE('Failed to Connect');
  mssql_select_db('DatabaseName') or DIE('Failed to Find Database');

  echo "<font size=4 color=0000ff><b><i>Report Title<b><i><font>";
  echo "<hr size=2 width=500>";

  $ss = "SELECT * FROM MyFile where AField = '" . $Something . "' ";
  $result = MSSQL_QUERY($ss); 
  $count = MSSQL_NUM_ROWS($result); 

  if ($count == 0) print "No data?"; 
  $i=0; 

  echo "<center>";
  while ($i < $count) :
    $Name = mssql_result($result,$i,"Name");
    $Addr = mssql_result($result,$i,"Addr");
    $City = mssql_result($result,$i,"City");

    print "<br><font color=228b22 size=2><i>" . $name . "<i><br> ";
    print "<a href=http://" . $Addr . ">Address<a><br>";
    print "<br><font color=228b22 size=2>" . $City . "<br> ";

    $i++;
  endwhile;

?> 

<body>
<html>
Hosted by www.Geocities.ws

1