php 分页用的代码

/*
Navic at MySQL Data Transfer
Order by              : happig
Source Server         : localhost
Source Server Version : 50516
Source Host           : localhost:3306
Source Database       : test
 
Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001
 
Date: 2012-08-25 02:21:44
*/
USE `pagelist`;
 
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `v_char`
-- ----------------------------
DROP TABLE IF EXISTS `v_char`;
CREATE TABLE `v_char` (
  `type_id` int(11) NOT NULL DEFAULT '0',
  `type_name` varchar(255) DEFAULT NULL,
  `type_parent_id` int(11) DEFAULT NULL,
  `project` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-- ----------------------------
-- Records of v_char
-- ----------------------------
INSERT INTO `v_char` VALUES ('1', '工装功能', null, 'gong');
INSERT INTO `v_char` VALUES ('2', '工装类型', null, 'gong');
INSERT INTO `v_char` VALUES ('3', '家装功能', null, 'jia');
INSERT INTO `v_char` VALUES ('4', '家装风格', null, 'jia');
INSERT INTO `v_char` VALUES ('5', '家装构件', null, 'jia');
INSERT INTO `v_char` VALUES ('6', '家装户型', null, 'jia');
INSERT INTO `v_char` VALUES ('10', '办公空间', '2', 'gong');
INSERT INTO `v_char` VALUES ('13', '中式', '4', 'jia');
INSERT INTO `v_char` VALUES ('14', '欧式', '4', 'jia');
INSERT INTO `v_char` VALUES ('16', '医院', '1', 'gong');
INSERT INTO `v_char` VALUES ('17', '办公室', '1', 'gong');
INSERT INTO `v_char` VALUES ('18', '网吧', '1', 'gong');
INSERT INTO `v_char` VALUES ('19', '超市', '1', 'gong');
INSERT INTO `v_char` VALUES ('20', '售楼部', '1', 'gong');
INSERT INTO `v_char` VALUES ('21', '餐厅', '1', 'gong');
INSERT INTO `v_char` VALUES ('22', '酒店', '1', 'gong');