<?php$conn=@mysql_connect("localhost","root","") or die ("rong!");
mysql_select_db("db",$conn);
mysql_query("SET NAMES 'GBK'");if(!empty($_POST['Submit'])){$sql=mysql_query("select * from tb_book",$conn);}while($rows=mysql_fetch_array($sql)){?>
<table>
<tr>
<td><?php echo $rows['id'];?></td>
<td><?php echo $rows['name'];?></td>
<td><?php echo $rows['pen'];?></td>
<td><?php echo $rows['pub'];?></td>
<td><?php echo $rows['date'];?></td>
<td><?php echo $rows['rate'];?></td>
</tr>
</table>
<?php
}
?>
<form action="" method="post">
<input type="submit" name="Submit" value="查询"/>
</form>上面的代码提示 :Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\PHP\wamp\www_local\Corporation\test.php on line 17
请高手帮忙解决下。
mysql_select_db("db",$conn);
mysql_query("SET NAMES 'GBK'");if(!empty($_POST['Submit'])){$sql=mysql_query("select * from tb_book",$conn);}while($rows=mysql_fetch_array($sql)){?>
<table>
<tr>
<td><?php echo $rows['id'];?></td>
<td><?php echo $rows['name'];?></td>
<td><?php echo $rows['pen'];?></td>
<td><?php echo $rows['pub'];?></td>
<td><?php echo $rows['date'];?></td>
<td><?php echo $rows['rate'];?></td>
</tr>
</table>
<?php
}
?>
<form action="" method="post">
<input type="submit" name="Submit" value="查询"/>
</form>上面的代码提示 :Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\PHP\wamp\www_local\Corporation\test.php on line 17
请高手帮忙解决下。
大侠是怎么样的原因啊?
按照乔丹的修改代码后测试一下.注意 @mysql_connect 去掉前面的 @
@去掉也还是错的。点击submit按钮后数据能正常显示的。