复制代码 代码如下:

<?php

$myServer="localhost";//主机

$myUser="sa";//用户名

$myPass="password";//密码

$myDB="Northwind";?//MSSQL库名

$s=@mssql_connect($myServer,$myUser,$myPass)

ordie("Couldn'tconnecttoSQLServeron$myServer");

$d=@mssql_select_db($myDB,$s)

ordie("Couldn'topendatabase$myDB");

$query="SELECTTitleOfCourtesy+''+FirstName+''+LastNameASEmployee";

$query.="FROMEmployees";

$query.="WHERECountry='USA'ANDLeft(HomePhone,5)='(206)'";

$result=mssql_query($query);

$numRows=mssql_num_rows($result);

echo"<h1>".$numRows."Row".($numRows==1?"":"s")."Returned</h1>";

while($row=mssql_fetch_array($result))

{

echo"<li>".$row["Employee"]."</li>";

}