按照大家的提示,已将mysql_numrows($result)改为mysql_num_rows($result),数据库中也确实有数据(50条),可是调试时还是报错 Warning: Supplied argument is not a valid MySQL result resource in C:\apache\htdocs\xitong\page.php on line 1313 $numb=mysql_num_rows($result); 修改后的代码片段 <? $limit=25; if (!empty($start)) $start=0; if (!empty($s)) $s=0; $connect=mysql_connect("localhost","",""); $select=mysql_select_db("licai",$connect);$result=mysql_query("select * from xiaofei"); $num=mysql_num_rows($result); $result=mysql_query("select * from xiaofei order by id limit $start,$limit"); $numb=mysql_num_rows($result); //统计数据库记录总数 echo "<table>"; if (!empty($numb)) { for($i=0;$i<$numb;$i++) { $val=mysql_result($result,$i,"id"); $val1=mysql_result($result,$i,"date"); echo "<tr><td>$val</td><td>$val1</td></tr>"; } } echo "</table>"; 以下的代码不变问题出在$numb=mysql_num_rows($result); 程序的原意是获取select * from xiaofei order by id limit $start,$limit 的数据行数,并通过循环显示数据 if (!empty($numb)) { for($i=0;$i<$numb;$i++) { $val=mysql_result($result,$i,"id"); $val1=mysql_result($result,$i,"date"); echo "<tr><td>$val</td><td>$val1</td></tr>"; 我试着将$numb=mysql_num_rows($result); 改$numb=25 可是仍然报错,真不知该如何修改??
mysql_num_rows和mysql_numrows都能显示正确$num,只是正确写法是前者! 把$result=mysql_query("select * from xiaofei order by id limit $start,$limit",$connect); 改成$query=mysql_query("select * from xiaofei order by id limit $start,$limit",$connect); 我得机子可以测试通过了,你试试!
跟据提示,诮该是: $result=mysql_query("select * from xiaofei order by id limit $start,$limit"); 这句的问题,你确信有id这个字段吗? 另外,根据意思,你前面的: if (!empty($start)) $start=0; if (!empty($s)) $s=0; 应该改成: if (empty($start)) $start=0; if (empty($s)) $s=0;
$result=mysql_query("select * from xiaofei order by id limit $start,$limit");改为 $query="select * from xiaofei order by id limit $start,$limit"; $result=mysql_query($query); 如果还不行,那你最好把报错的内容写出来
按照大家的提示,已将mysql_numrows($result)改为mysql_num_rows($result),数据库中也确实有数据(50条),可是调试时还是报错
Warning: Supplied argument is not a valid MySQL result resource in C:\apache\htdocs\xitong\page.php on line 1313 $numb=mysql_num_rows($result); 修改后的代码片段
<?
$limit=25;
if (!empty($start)) $start=0;
if (!empty($s)) $s=0; $connect=mysql_connect("localhost","","");
$select=mysql_select_db("licai",$connect);$result=mysql_query("select * from xiaofei");
$num=mysql_num_rows($result); $result=mysql_query("select * from xiaofei order by id limit $start,$limit");
$numb=mysql_num_rows($result);
//统计数据库记录总数
echo "<table>";
if (!empty($numb)) {
for($i=0;$i<$numb;$i++) {
$val=mysql_result($result,$i,"id");
$val1=mysql_result($result,$i,"date");
echo "<tr><td>$val</td><td>$val1</td></tr>";
}
}
echo "</table>";
以下的代码不变问题出在$numb=mysql_num_rows($result);
程序的原意是获取select * from xiaofei order by id limit $start,$limit
的数据行数,并通过循环显示数据
if (!empty($numb)) {
for($i=0;$i<$numb;$i++) {
$val=mysql_result($result,$i,"id");
$val1=mysql_result($result,$i,"date");
echo "<tr><td>$val</td><td>$val1</td></tr>";
我试着将$numb=mysql_num_rows($result); 改$numb=25
可是仍然报错,真不知该如何修改??
把$result=mysql_query("select * from xiaofei order by id limit $start,$limit",$connect);
改成$query=mysql_query("select * from xiaofei order by id limit $start,$limit",$connect); 我得机子可以测试通过了,你试试!
$result=mysql_query("select * from xiaofei order by id limit $start,$limit");
这句的问题,你确信有id这个字段吗?
另外,根据意思,你前面的:
if (!empty($start)) $start=0;
if (!empty($s)) $s=0;
应该改成:
if (empty($start)) $start=0;
if (empty($s)) $s=0;
$query="select * from xiaofei order by id limit $start,$limit";
$result=mysql_query($query);
如果还不行,那你最好把报错的内容写出来