//一个显示数据的例子,其它类似。
<?php 
$cn=mssql_connect("192.168.0.9","sa","");
mssql_select_db("Northwind",$cn);
$sql="select  * from Products";
$rs=mssql_query($sql,$cn);
         $numrows=mssql_num_rows($rs);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
<table width="80%" height="25" border="1" cellpadding="0" cellspacing="0">
    <tr>
        <td width="8%" height="18">ProductID</td>
        <td width="10%">ProductName</td>
        <td width="10%">SupplierID</td>
        <td width="9%">CategoryID</td>
        <td width="13%">QuantityPerUnit</td>
        <td width="8%">UnitPrice</td>
        <td width="11%">UnitsInStock</td>
        <td width="12%">'UnitsOnOrder</td>
        <td width="10%">ReorderLevel</td>
        <td width="9%">'Discontinued</td>
    </tr><?php 
for ($i=0;$i<$numrows;$i++){
$arr=mssql_fetch_array($rs);
echo "<tr>";
echo "<td>".$arr['ProductID']."</td>";
        echo "<td>".$arr['ProductName']."</td>";
        echo "<td>".$arr['SupplierID']."</td>";
echo "<td>".$arr['CategoryID']."</td>";
        echo "<td>".$arr['QuantityPerUnit']."</td>";
echo "<td>".$arr['UnitPrice']."</td>";
        echo "<td>".$arr['UnitsInStock']."</td>";
        echo "<td>".$arr['UnitsOnOrder']."</td>";
        echo "<td>".$arr['ReorderLevel']."</td>";
        echo "<td>".$arr['Discontinued']."</td>";
echo "</tr>";
}
?>
</table>
</body>
</html>