数据库是mssql的。在查询分析器里运行该语句没问题。但是。我在网站里用结果就是不一样。
select top 6 * from WEB_VIEW where DNBH='$username' order by SFMonth desc
在mssql查询分析器里，运行，得到6条最新的结果， 但是，在页面上测试，就只能得到5条记录，少了最新那一条。
难道6 改为 7 ？
//connection to the database$dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("连接不上数据库"); //select a database to work with$selected = mssql_select_db($myDB, $dbhandle) or die("连接不上指定数据库"); $username=trim($_POST['username']);$password=trim($_POST['pass']);//declare the SQL statement that will query the database$query = "select top 6 * from WEB_VIEW where DNBH='$username' order by SFMonth desc ";//execute the SQL query and return records$result = mssql_query($query) or die ("查询数据失败: ".mysql_error());$numRows = mssql_num_rows($result); $nRow=mssql_fetch_array($result);if ($password <> substr($nRow[3],-4)) {echo "输入有误，请正确输入用户名和密码。谢谢！
";}else { if (empty($numRows)) echo "没有查到数据哦，请正确输入用户名和密码。谢谢！
"; else { //$nRow=mssql_fetch_array($result); echo "你好！电脑编号为"; echo "$username"; echo ","; echo "户名"; echo "$nRow[2]"; echo "| 月份 | 总费用 |
|---|---|
| "; echo $row[1]; echo" | "; echo""; echo ($row[10]+$row[4]); echo" | "; echo"
| "; echo $row[1]; echo" | "; "; echo ($row[10]+$row[4]); echo" | ";