一个简单的mysql数据库分页的程序模板（初学者进）

1   
2$link = mysql_connect('localhost', 'root', '') or die('mysql database connect error');   
3mysql_select_db('your database') or die('the selected database is not exist');   

 1   
 2$sql = 'select count(*) count from your_table';   
 3$result = mysql_query($sql) or die(mysql_errno().": ".mysql_error()."\n");   
 4$rs=mysql_fetch_object($result);   
 5$recountCount = $rs->count;   
 6$show = 20;   
 7$totalPage = ceil($recountCount/$show);   
 8$page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0;   
 9$isLast = ($page==($totalPage-1))? true: false;   
10$hasNoPre = ($page==0)? true: false;   
11$hasNoNext = ($page==$totalPage-1)? true: false;   
12$isFirst = ($page==0)? true:false;   
13$start = $page*$show;   
14mysql_free_result($result);