这是数据库脚本
# MySQL-Front Dump 2.5
#
# Host: localhost Database: dfzq
# --------------------------------------------------------
# Server version 4.0.20a-nt
#
# Table structure for table 'liuyan'
#CREATE TABLE liuyan (
number smallint(10) NOT NULL auto_increment,
corp varchar(50) NOT NULL default '',
name varchar(50) NOT NULL default '',
phone varchar(50) NOT NULL default '',
address varchar(50) NOT NULL default '',
Email varchar(50) NOT NULL default '',
content text NOT NULL,
times datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (number),
KEY number (number)
) TYPE=MyISAM;#
# Dumping data for table 'liuyan'
#INSERT INTO liuyan VALUES("10", "qqqqqq", "qqqqqqq", "qqqqqqqqqq", "qqqqqqqqqq", "[email protected]", "qqqqqqqqqqqqqqqqq", "2004-07-17 00:31:22");
INSERT INTO liuyan VALUES("8", "aaaaaaaa", "aaaaaaaaa", "aaaaaaaaa", "aaaaaaa", "aaaaaaaa", "aaaaaaaaaa", "2004-07-11 23:12:52");
INSERT INTO liuyan VALUES("9", "bbbbbbbbbb", "bbbbbbbbbbbbbb", "bbbbbbbbbbb", "bbbbbbbbbbbbb", "bbbbbbbbbbbbb", "bbbbbbbbbbbbbbbbbb", "2004-07-11 23:13:06");
INSERT INTO liuyan VALUES("11", "dddddddd", "dddddddddd", "dddddddddd", "dddddddddd", "[email protected]", "[email protected]", "2004-07-17 20:12:16");
INSERT INTO liuyan VALUES("12", "sssssss", "ssssssss", "sssssssssss", "ssssssss", "[email protected]", "[email protected]", "2004-07-17 20:12:48");
INSERT INTO liuyan VALUES("13", "wwwwwww", "wwwwwwwww", "wwwwwwwwwww", "wwwwwwwww", "[email protected]", "[email protected]", "2004-07-17 20:13:01");
INSERT INTO liuyan VALUES("14", "qqqqqqqqq", "qqqqqqqqqqqq", "qqqqqqqqq", "qqqqqqqqqq", "[email protected]", "[email protected]", "2004-07-17 20:13:15");
INSERT INTO liuyan VALUES("15", "aaaaaaaaaa", "aaaaaaaaaaa", "aaaaaaaaaaa", "aaaaaaaaaaaaaaa", "[email protected]", "ssssssssssssssss", "2004-07-17 20:13:45");
INSERT INTO liuyan VALUES("16", "fffffffff", "ffffffffff", "ffffffffffff", "fffffffff", "[email protected]", "fffffffffffff", "2004-07-17 20:13:57");
INSERT INTO liuyan VALUES("17", "xxxxxxxx", "xxxxxxxxxxxx", "xxxxxxxxxx", "xxxxxxxxxx", "[email protected]", "[email protected]", "2004-07-17 20:14:35");
#
# Table structure for table 'users'
#CREATE TABLE users (
us varchar(20) NOT NULL default '',
pass varchar(20) NOT NULL default '',
PRIMARY KEY (us)
) TYPE=MyISAM;#
# Dumping data for table 'users'
#INSERT INTO users VALUES("dfzq", "dfzq");
# MySQL-Front Dump 2.5
#
# Host: localhost Database: dfzq
# --------------------------------------------------------
# Server version 4.0.20a-nt
#
# Table structure for table 'liuyan'
#CREATE TABLE liuyan (
number smallint(10) NOT NULL auto_increment,
corp varchar(50) NOT NULL default '',
name varchar(50) NOT NULL default '',
phone varchar(50) NOT NULL default '',
address varchar(50) NOT NULL default '',
Email varchar(50) NOT NULL default '',
content text NOT NULL,
times datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (number),
KEY number (number)
) TYPE=MyISAM;#
# Dumping data for table 'liuyan'
#INSERT INTO liuyan VALUES("10", "qqqqqq", "qqqqqqq", "qqqqqqqqqq", "qqqqqqqqqq", "[email protected]", "qqqqqqqqqqqqqqqqq", "2004-07-17 00:31:22");
INSERT INTO liuyan VALUES("8", "aaaaaaaa", "aaaaaaaaa", "aaaaaaaaa", "aaaaaaa", "aaaaaaaa", "aaaaaaaaaa", "2004-07-11 23:12:52");
INSERT INTO liuyan VALUES("9", "bbbbbbbbbb", "bbbbbbbbbbbbbb", "bbbbbbbbbbb", "bbbbbbbbbbbbb", "bbbbbbbbbbbbb", "bbbbbbbbbbbbbbbbbb", "2004-07-11 23:13:06");
INSERT INTO liuyan VALUES("11", "dddddddd", "dddddddddd", "dddddddddd", "dddddddddd", "[email protected]", "[email protected]", "2004-07-17 20:12:16");
INSERT INTO liuyan VALUES("12", "sssssss", "ssssssss", "sssssssssss", "ssssssss", "[email protected]", "[email protected]", "2004-07-17 20:12:48");
INSERT INTO liuyan VALUES("13", "wwwwwww", "wwwwwwwww", "wwwwwwwwwww", "wwwwwwwww", "[email protected]", "[email protected]", "2004-07-17 20:13:01");
INSERT INTO liuyan VALUES("14", "qqqqqqqqq", "qqqqqqqqqqqq", "qqqqqqqqq", "qqqqqqqqqq", "[email protected]", "[email protected]", "2004-07-17 20:13:15");
INSERT INTO liuyan VALUES("15", "aaaaaaaaaa", "aaaaaaaaaaa", "aaaaaaaaaaa", "aaaaaaaaaaaaaaa", "[email protected]", "ssssssssssssssss", "2004-07-17 20:13:45");
INSERT INTO liuyan VALUES("16", "fffffffff", "ffffffffff", "ffffffffffff", "fffffffff", "[email protected]", "fffffffffffff", "2004-07-17 20:13:57");
INSERT INTO liuyan VALUES("17", "xxxxxxxx", "xxxxxxxxxxxx", "xxxxxxxxxx", "xxxxxxxxxx", "[email protected]", "[email protected]", "2004-07-17 20:14:35");
#
# Table structure for table 'users'
#CREATE TABLE users (
us varchar(20) NOT NULL default '',
pass varchar(20) NOT NULL default '',
PRIMARY KEY (us)
) TYPE=MyISAM;#
# Dumping data for table 'users'
#INSERT INTO users VALUES("dfzq", "dfzq");
if($num%$pagesize>0){
$pagecount=intval(($num/$pagesize)+1); //当总记录数除以每页记录数有余数时取的总的页数
}
else{
$pagecount=intval($num/$pagesize);
}
}
///////////////////////////////////
$num%$pagesize
/////////////////////%符号错了
if(isset($_GET['page'])){
$page=intval( $_GET['page'] );
}
else{
$page=1;
}
把
else{
$page=1;
}
去掉就好了,很正常;上面的代码已经通过测试,很爽;