警告：mysql_num_rows（）要求参数1为资源，布尔值在第56行的C：\ wamp \ www \ AB-FASHION \ order_success.php中给出[复制]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers
• ERROR: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\…\…php on line 19 7 answers

Here i am trying to get the order info from the user and then by confirming order i want to show the order id to the user as the tracking for the order... but it showing me error as stated above my code is here:

    <?php 
   // This block grabs the whole list for viewing
   $product_list1 = "";
   $sql = mysql_query("SELECT FROM orders ORDER BY id DESC LIMIT 1");
   $orderCount = mysql_num_rows($sql);
   if ($orderCount > 0) {
while($row = mysql_fetch_array($sql)){ 
         $id = $row["id"];

         $product_list1 .= "Your Order ID : $id ";
     }
     } else {
$product_list1 = "You have no products listed in your store yet";
    }
    ?>

</div>

Answer 1

Specify what need to be selected from your database table. For eg.

Specific column (coulmn name)

$sql = mysql_query("SELECT coulmnName FROM orders ORDER BY id DESC LIMIT 1");

Or all columns (using *)

$sql = mysql_query("SELECT * FROM orders ORDER BY id DESC LIMIT 1");