mysql_fetch_array（）期望参数1是资源，给定布尔值 [英] mysql_fetch_array() expects parameter 1 to be resource, boolean given

问题描述

mysql_fetch_array（）期望参数1是资源，在while循环参数中给出布尔值。

 $ results = mysql_query（  SELECT * FROM order_details WHERE orderid = $ orderid）; 
 
  print    SELECT * FROM order_details WHERE orderid = $ orderid; 
 
  $ productid ; 
  $ quantity ; 
  $ price ; 
 
  $ resultset  = array（）; 
  while （$ row = mysql_fetch_arraY（$ results））{
 $ resultset [] =  $行; 
} 
 
  foreach （$ resultset  as  $ result）
 {
  print    1 ; 
 
  / *   $ productid = $ result ['productid']; 
 $ quantity = $ result ['quantity']; 
 $ price = $ result ['price']; * /  
 
  //   print< br /> $ productid，$ quantity，$ price;  
}; 

解决方案

results = mysql_query（ SELECT * FROM order_details WHERE orderid =

订单ID）;

print SELECT * FROM order_details WHERE orderid =

orderid;

mysql_fetch_array() expects parameter 1 to be resource, boolean given in the while loop argument.

$results=mysql_query("SELECT * FROM order_details WHERE orderid = $orderid");
		
		print "SELECT * FROM order_details WHERE orderid = $orderid";
		
		$productid;
		$quantity;
		$price;
		
		$resultset = array();
while ($row = mysql_fetch_arraY($results)) {
  $resultset[] = $row;
}
		
		foreach ($resultset as $result)
		{
		print "1";
		
		/*$productid = $result['productid'];
		$quantity = $result['quantity'];
		$price = $result['price'];*/
		
		//print "<br />$productid, $quantity, $price";
		};

解决方案

results=mysql_query("SELECT * FROM order_details WHERE orderid =

orderid"); print "SELECT * FROM order_details WHERE orderid =

orderid";

这篇关于mysql_fetch_array（）期望参数1是资源，给定布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！