原来的时候我打开下面的php文件,在页面上可以显示出来正确的结果,可是,后来我将php+apache5.0+mysql全部重新装了之后,打开下面的文件,就提示:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\web\try1.php on line 6
我的代码如下:
<?php
mysql_connect("localhost","root","ps") or
die("Could not connect:".mysql.error());
mysql_select_db("try1");
$result=mysql_query("SELECT card_num,card_name FROM card");
while($row = mysql_fetch_array($result))
{
echo $row[card_num]."|".$row[card_name]."<br>";
}
?>
ps:我检查了数据库是可以连上的,但是只要是有sql语句,就一直报错!请各位帮帮忙!!
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\web\try1.php on line 6
我的代码如下:
<?php
mysql_connect("localhost","root","ps") or
die("Could not connect:".mysql.error());
mysql_select_db("try1");
$result=mysql_query("SELECT card_num,card_name FROM card");
while($row = mysql_fetch_array($result))
{
echo $row[card_num]."|".$row[card_name]."<br>";
}
?>
ps:我检查了数据库是可以连上的,但是只要是有sql语句,就一直报错!请各位帮帮忙!!
mysql_connect("localhost","root","ps") or
die("Could not connect:".mysql.error());
mysql_select_db("try1");
$result=mysql_query("SELECT card_num,card_name FROM card");
while($row = @mysql_fetch_array($result)) //加一个@
{
echo $row[card_num]."|".$row[card_name]."<br>";
}
?>
这句在MySQL中执行能返回结果吗?
我用下面的代码:
<?php
$connect=mysql_connect("localhost","root","ps");
$select=mysql_select_db('library',$connect);
$query="SELECT card_num,card_name FROM card";
$result=mysql_query($query);
if($result) echo "Succeeded!";
else echo "Failed!";
?>返回的结果是 Succeeded!
应该是对的
SELECT card_num,card_name FROM card