title: Warning: mysql_num_rows() expects parameter 1 to be resource, array given in
body: <p>Hey guys, I need your help. What can be my problem why its giving me this Errror as mentioned in the Title?</p>
  
  <p>Here is my code:</p>
  
  <pre><code> if (!$connect){ 
          die("Failed to connect to the database: ".mysql_error()); 
      } 
  $kies_bd = mysql_select_db("eraenz_db1",$connect); 
      if (!$kies_bd){ 
          die("failed to choose from BD: ".mysql_error()); 
      } 
  $query = mysql_query("SELECT ListNumber FROM residential");// or die($myQuery."&lt;br/&gt;&lt;br/&gt;".mysql_error()); 
  $result1 =  mysql_fetch_assoc($query) or die($myQuery."&lt;br/&gt;&lt;br/&gt;".mysql_error()); 
  echo $result1;
      if (mysql_num_rows($result1) &gt;10){ 
          $difference = mysql_num_rows($result1) - 10; 
          $myQuery = mysql_query("SELECT * FROM residential ORDER BY ListNumber LIMIT 10,". $difference) ; 
  </code></pre>