www.jiang007.cn 网址 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/users/jiang007.cn/index.php on line 188Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /www/users/jiang007.cn/index.php on line 203
$resultc=mysql_query($execc);
$rsc=mysql_fetch_array($resultc);
$num=$rsc[0];
ceil($num/10);
if(empty($_GET['page']))
{
$page=0;
}
else
{
$page=$_GET["page"];
if($page<0)$page=0;
if($page>=ceil($num/10))$page=ceil($num/10)-1;
}
$exec="select * from guestbook order by id desc limit ".($page*10).",10";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
$total = mysql_num_rows($sql);
$nextpg = 0;
if($total <= $max_rows)
{
while($tt = mysql_fetch_array($sql))
{
$name = $tt['name'];
echo $name."<br>";
}
}else
{
$pagenum = $_GET['pageid'] * $max_rows;
if(!$_GET['pageid'])
{
$pagenum = 0;
}
$lastpg=ceil($total/$max_rows)-1;
$nextpg=($pageid==$lastpg ? 0 : $pageid+1);
$sql2 = mysql_query("select * from products limit ".$pagenum.",".$max_rows);
while($ttt = mysql_fetch_array($sql2))
{
$name1 = $ttt['name'];
echo $name1."<br>";
}
echo "<a href='?pageid=0'>frist page</a> ";
echo "<a href='?pageid=$nextpg'>next page</a> ";
echo "<a href='?pageid=$lastpg'>last page</a>";";
}
试试$exec="select * from guestbook order by id desc limit ".intval($page*10).",10";