<?php
$conn=@mssql_connect("127.0.0.1","sa","cc");
@mssql_select_db("sql2008");
$sql = "SELECT * FROM StreamServerIP";
$row=@mssql_query(sql);
while($bk=@mssql_fetch_array($row))
{
echo $bk[1];
}
?>帮忙处理一下
$conn=@mssql_connect("127.0.0.1","sa","cc");
@mssql_select_db("sql2008");
$sql = "SELECT * FROM StreamServerIP";
$row=@mssql_query(sql);
while($bk=@mssql_fetch_array($row))
{
echo $bk[1];
}
?>帮忙处理一下
$conn=mssql_connect("127.0.0.1","sa","cc") or die(;
mssql_select_db("sql2008");
$sql = "SELECT * FROM StreamServerIP";
$row=mssql_query(sql);
while($bk=mssql_fetch_array($row)) {
echo $bk[1];
}
?> 再看有没有错误信息.
注意服务器的错误显示级别.
把它去掉,看下错误信息!
看了下代码,好像没什么错!
估计错在sql语句,检查一下就行!
$conn=mssql_connect("127.0.0.1","sa","sa");
$dbname=mssql_select_db("fang",$conn)
or die("Can't connect to database.");
$sql="select * from d_member";
$query = mssql_query($sql,$conn);
echo"<table border=1>";
echo"<tr><td>M_Name</td>";
echo"<td>M_sex</td>";
echo"<td>M_age</td></tr>";
while($row = mssql_fetch_array($query))
{
echo"<tr>";
echo"<td>".$row['M_Name']."</td>";
echo"<td>".$row['M_Sex']."</td>";
echo"<td>".$row['M_Age']."</td>";
echo"</tr>";
}
echo"</table>";mssql_close();
这个是我测试的,已经可以使用。无错的。
$conn=@mssql_connect("127.0.0.1","sa","cc");
@mssql_select_db("sql2008");
$sql = "SELECT * FROM StreamServerIP";
$row=@mssql_query($sql);
while($bk=@mssql_fetch_array($row))
{
echo $bk[1];
}
?>
少个$把.....