去掉你里面的分页信息,我想肯定就会正确了。
我好像没见过你那样子的while格式
<?
$conn = mssql_connect("zhouwh", "sa", "sa");
mssql_select_db("ysjg",$conn);
$sql="select * from user_add";
$result=mssql_query($sql,$conn);
$Rs=mssql_fetch_array($result);
$max = mssql_num_rows($result);
$pagesize =20;
$pageno = intval($pageno);
if ($pageno == 0) { $pageno = 1; $D1 = 1; }
if ($pageno == 1) { $D1 = 1;}
$totalpages=(($max - ($max % $pagesize)) / $pagesize);
if (($max % $pagesize) > 0) $totalpages = $totalpages+1;
$row = $pagesize*$pageno-$pagesize;
$i = 0;
while ($RS = mssql_fetch_row($result))
{
?>
<option><?echo $Rs["truename"]?></option>
<?
}
?>
我好像没见过你那样子的while格式
<?
$conn = mssql_connect("zhouwh", "sa", "sa");
mssql_select_db("ysjg",$conn);
$sql="select * from user_add";
$result=mssql_query($sql,$conn);
$Rs=mssql_fetch_array($result);
$max = mssql_num_rows($result);
$pagesize =20;
$pageno = intval($pageno);
if ($pageno == 0) { $pageno = 1; $D1 = 1; }
if ($pageno == 1) { $D1 = 1;}
$totalpages=(($max - ($max % $pagesize)) / $pagesize);
if (($max % $pagesize) > 0) $totalpages = $totalpages+1;
$row = $pagesize*$pageno-$pagesize;
$i = 0;
while ($RS = mssql_fetch_row($result))
{
?>
<option><?echo $Rs["truename"]?></option>
<?
}
?>
while语句会从库中one by one的取出数据。
while ($RS = mssql_fetch_row($result))