PHP Message Board code [classic Pagination Code] (1/4)

/*
SQL Database Tutorial Structure
--phpMyAdmin SQL Dump
--Version 2.11.6
--
--Host: localhost
--Date Created: November 08, 2009 08:22
--Server version: 5.0.51
--PHP version: 5.2.6

SET sql_mode= "No_auto_value_on_zero";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET_CLIENT * *;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS =@ @CHARACTER_SET_RESULTS * *;
/*!40101 SET @OLD_COLLATION_CONNECTION =@ @COLLATION_CONNECTION * *;
/*!40101 SET NAMES UTF8;

--
--Database: ' myde520 '
--

-- --------------------------------------------------------

--
--The structure of the table ' News '
--

CREATE TABLE ' News ' (
' ID ' int (a) not NULL auto_increment,
' title ' varchar character Set GBK default NULL,
' Content ' text character set GBK,
' Date ' date default NULL,
PRIMARY KEY (' id ')
) Engine=innodb DEFAULT charset=gb2312 auto_increment=9;

--
--Export the data in the table ' News '
--

INSERT into ' news ' (' id ', ' title ', ' content ', ' date ') VALUES
(1, ' See blog post ', ' See blog URL http://www.111cn.net ', ' 2009-11-08 '),
(2, ' treasure-seekers ' website is published ', ' The website of treasure-seekers is http://www.111cn.net, hope everybody often come to see ', ' 2009-11-08 '),
(3, ' Xiao Xian home site announced ', ' Xiao Xian home http://www.111cn.net ', ' 2009-11-08 '),
(4, ' Guilin Specialty website announces ', ' Guilin specialty website Htttp://www.111cn.net ', ' 2009-11-08 '),
(5, ' Yangshuo Fairyland Hotel website announced ', ' Yangshuo Wonderland Hotel URL http://www.111cn.net ', ' 2009-11-08 '),
(6, ' Health Church website published ', ' Health Church web site Http://www.111cn.net ', ' 2009-11-08 '),
(7, ' treasure-seekers online 25 days ', ' treasure-seekers online 25 days, Baidu and Google have included 1000! http://www.111cn.net ', ' 2009-11-08 ');

*/
HTML code

?>

Home 1 2 3 4 last page