Php+ajax paging, how to resolve

Php+ajax Sub-page






#header ("content-type:text/html;charset=gb2312");
$pagesize = 10;
echo $_post[' page ';
$db =mysql_connect ("localhost", "root", ""); Create a database connection
mysql_query ("Set names GBK");
mysql_select_db ("PageList");
$result = mysql_query ("Select * from Sheet1", $db);
$myrow = Mysql_fetch_array ($result);
$numrows =mysql_num_rows ($result);
$pages =intval ($numrows/$pagesize);
if ($numrows% $pagesize)
$pages + +;
if (Isset ($_post[' page ')) {
$page =intval ($_post[' page ');
}
else{
Set as first page
$page = 1;
}
$first = 1;
$prev = $page-1;
$next = $page +1;
$last = $pages;
Calculate record offset
$offset = $pagesize * ($page-1);
Reads the specified number of records

$result =mysql_query ("Select ' ID ', COUNT (*) from". GROUP by ' ID ' ORDER BY id desc limit $offset, $pagesize ");
$result =mysql_query ("select * from Sheet1 limit $offset, $pagesize");
$num = mysql_num_rows ($result);
while ($row = Mysql_fetch_array ($result, $db)) {
$hotelname [] = $row [0];
$name []= $row [1];
$author []= $row [2];
$publisher []= $row [3];
$ISBN []= $row [4];
$type []= $row [5];
$smallpic []= $row [6];
$countpeople [] = $row [1];
}
echo "



\ n "; echo " \ n"; echo " th> type "; for ($a =0; $a < $num; $a + +) {echo " \ n"; echo " ";

ID number	name	author	publisher	ISBN number	price
"; echo "	"; echo "	"; echo "	"; echo "	"; echo "	"; #echo "