Home >Backend Development >PHP Tutorial >Warning: mysql_fetch_array():_PHP教程
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
$connect=mysql_connect("localhost","root","123") or die("Unable to connect to database".mysql_error());
mysql_select_db("cmstest") or die("Unable to select database".mysql_errno());
$sql="select * from article where pid=1";
$result=mysql_query($sql,$connect) or die("Unable to query sql statement".mysql_error());
$nums=mysql_num_rows($result);
echo "nums is:".$nums;
while($res=mysql_fetch_array($result)){
echo $res[0];
}
It turns out that $result is repeated.