我的代码如下:
<?
//设置当前页显示的数量(这个数量可任意设置)
$limit=20;//初始化数据库搜索起始记录
if (!empty($start)) $start=0;mysql_connect("localhost","root","123456");
mysql_select_db("message");//设置数据库记录总数
$result=mysql_query("select * from message");
$num_max=mysql_numrows($result);
$query="select * from message order by id desc limit $start,$limit";
$result=mysql_query($query);
$num=mysql_num_rows($result);echo "<table><tr><td>翻页功能</td></tr>";if (!empty($num)) {
for ($i=0;$i<$num;$i++) {
$val=mysql_result($result,$i,"val");
$val1=mysql_result($result,$i,"val1");
echo "<tr><td>$val</td><td>$val1</td></tr>";
}
}echo "<tr><td>";//设置向前翻页的跳转
$prve=$start-$limit;
if ($prve>=0) {
echo "<a href=page.php?start=$prve>prve</a>";
}//设置向后翻页的跳转
$next=$start+$limit;
if ($next<$num_max) {
echo "<a href=page.php?start=$next>next</a>";
}echo "</td></tr></table>";
?>
为什么老是提示:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\PHP\www_local\NoteBook\page.php on line 16
错误是在:$num=mysql_num_rows($result);麻烦知道的高手回答一下啊。
<?
//设置当前页显示的数量(这个数量可任意设置)
$limit=20;//初始化数据库搜索起始记录
if (!empty($start)) $start=0;mysql_connect("localhost","root","123456");
mysql_select_db("message");//设置数据库记录总数
$result=mysql_query("select * from message");
$num_max=mysql_numrows($result);
$query="select * from message order by id desc limit $start,$limit";
$result=mysql_query($query);
$num=mysql_num_rows($result);echo "<table><tr><td>翻页功能</td></tr>";if (!empty($num)) {
for ($i=0;$i<$num;$i++) {
$val=mysql_result($result,$i,"val");
$val1=mysql_result($result,$i,"val1");
echo "<tr><td>$val</td><td>$val1</td></tr>";
}
}echo "<tr><td>";//设置向前翻页的跳转
$prve=$start-$limit;
if ($prve>=0) {
echo "<a href=page.php?start=$prve>prve</a>";
}//设置向后翻页的跳转
$next=$start+$limit;
if ($next<$num_max) {
echo "<a href=page.php?start=$next>next</a>";
}echo "</td></tr></table>";
?>
为什么老是提示:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\PHP\www_local\NoteBook\page.php on line 16
错误是在:$num=mysql_num_rows($result);麻烦知道的高手回答一下啊。
$query="select * from message order by id desc limit $start,$limit";
echo $query;//将输出的结果到MYSQL中运行
$result=mysql_query($query);
$num=mysql_num_rows($result);
输出的结果是什么?
你自己也看到拉
$start是空值!肯定就错了
/设置当前页显示的数量(这个数量可任意设置)
$limit=20;
$start=$_GET['start'];
//初始化数据库搜索起始记录
if(empty($start)){
$start=0;
}
mysql_connect("localhost","root","123456");
mysql_select_db("message"); /设置向前翻页的跳转
$prve=$start-$limit;
if ($prve>=0) {
echo " <a href=page.php?start=$prve>prve </a>";//$prve>prve?应该是$prve吧
}//设置向后翻页的跳转
$next=$start+$limit;
if ($next <$num_max) {
echo " <a href=page.php?start=$next>next </a>";//$next>next 应该是$next吧
}
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
Warning: mysql_result() [function.mysql-result]: val not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 19Warning: mysql_result() [function.mysql-result]: val1 not found in MySQL result index 4 in E:\PHP\www_local\NoteBook\page.php on line 20
$limit=20;
$start=$_GET['start'];
//初始化数据库搜索起始记录
if (empty($start))
{
$start=0;
}
mysql_connect("localhost","root","123456");
mysql_select_db("message");//设置数据库记录总数
$result=mysql_query("select * from message");
$num_max=mysql_numrows($result);
$query="select * from message order by id desc limit $start,$limit";
$result=mysql_query($query);
$num=mysql_num_rows($result);echo " <table> <tr> <td>翻页功能 </td> </tr>";if (!empty($num)) {
for ($i=0;$i <$num;$i++) {
$val=mysql_result($result,$i,"val");
$val1=mysql_result($result,$i,"val1");
echo " <tr> <td>$val </td> <td>$val1 </td> </tr>";
}
}echo " <tr> <td>";//设置向前翻页的跳转
$prve=$start-$limit;
if ($prve>=0) {
echo " <a href=page.php?start=$prve</a>";
}//设置向后翻页的跳转
$next=$start+$limit;
if ($next <$num_max) {
echo " <a href=page.php?start=$next</a>";
}echo " </td> </tr> </table>";
$query="select * from message order by id desc limit $start,$limit";
改为:
$query="select * from message order by id desc limit ".$start.",".$limit;我也是同样的问题,但是我解决了,是SQL语句的问题,