$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
这是怎么回事啊???
麻烦各位大神看看~谢谢!