title: PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
body: <p>After uploading the site to my web server I get this message: </p>
  
  <pre><code>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource 
  in /home1/m1k3ey/public_html/MikeyDev.com/teamdesire/playersheet.php on line 8
  
  Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource 
  in /home1/m1k3ey/public_html/MikeyDev.com/teamdesire/playersheet.php on line 9
  </code></pre>
  
  <p>My PHP version is: </p>
  
  <p><code>PHP Version 5.2.17</code></p>
  
  <p>I cant see where im going wrong in my code, can anyone please assist:</p>
  
  <pre><code>          mysql_select_db('teamdesire', $link);
            $query = "SELECT * FROM playershowercase";
            $result = mysql_query($query,$link);
            $row = array();
  Line 8 &gt;  while($row[] = mysql_fetch_array($result));
  Line 9 &gt;  $count = mysql_num_rows($result);
            $random = rand(0,$count-1);
  </code></pre>