Warning: mysql_num_rows (): suppliedargumentisnotavalidMySQLresultresourc & lt; html & gt; & lt; head & gt; & lt; meta & nbsp; http-equiv = "Content-Type" Warning: mysql_num_rows (): supplied argument is not a valid MySQL result resourc
Untitled Document
Include ("conn. php ");
$ SQL = "SELECT * FROM 'liuyanban' order by id desc ";
$ Query = mysql_query ($ SQL );
$ Total = mysql_num_rows ($ query );
$ Pagesize = 3;
$ End_page = ceil ($ total/$ pagesize );
$ Page = $ _ GET ['Page']; // The current page.
If ($ page <= 0)
{
$ Page = 1;
}
If ($ page> $ end_page)
{
$ Page = $ end_page;
}
$ Start = ($ page-1) * $ pagesize;
$ SQL = "select * from liuyanban limit $ start, $ pagesize ";
// Mysql_query ("set names 'gbk '");
$ Ros = mysql_query ($ SQL, $ connect );
?>
Echo "message Table ";
Echo"
";
Echo "current page [$ page], [$ end_page] page ";
If ($ page = 1)
{
?>
Homepage
} Else
{
?>
Homepage
}
?>
"> Previous Page
"> Next page
If ($ page = $ end_page)
{
?>
Last page
} Else
{
?>
"> Last Page
}
?>
Member table
Name
Email
Message content
Operation
While ($ row = mysql_fetch_array ($ ros )){
?>
"> Modify"> Delete
}
?>
Add member table records
Share:
