mysql查看第二页_提取form值查询mysql后分页第一页正常第二页出错了是什么问题？...

$resultTable = mysql_query("SHOW TABLES");

while($row = mysql_fetch_array($resultTable)){

echo "".$row[0]."";

}

$name = $_REQUEST['fname'];

$length=3;

$pagenum=@$_GET['page']?$_GET['page']:1;

$sqltot="select count(*) from $name";

$arrtot=mysql_fetch_row(mysql_query($sqltot));

$pagetot=ceil($arrtot[0]/$length);

if($pagenum>=$pagetot){

$pagenum=$pagetot;

}

$offset=($pagenum-1)*$length;

$sql = "SELECT * FROM $name LIMIT {$offset},{$length}";

$result = mysql_query($sql);

echo "

while($row=mysql_fetch_assoc($result)){

echo "

";

echo "

{$row['num1']}";

echo "

{$row['num2']}";

echo "

{$row['num3']}";

echo "

";

}

echo "

";

$prevpage=$pagenum-1;

$nextpage=$pagenum+1;

echo "

上一页下一页

";

mysql_close($conn);

?>

第一页还能正确的分页并显示数据，一按下一页就出错了：

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in D:ServerWebshowdata.php on line 57

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in D:ServerWebshowdata.php on line 67

这是怎么回事啊？？？

麻烦各位大神看看~谢谢！