title: MYSQL does not return result in PHP when asked for the first ranking only
body: <p>I am trying to get hold of 1 record from a MySQL table using PHP. I have tried many different SELECT statements, while they all work in MYSQL they refuse to return any result in php.</p>
  
  <p>The countriesRanking table is a simple two column table</p>
  
  <pre><code>country    clicks
  ------     ------
  0        222
  66       34 
  175      1000
  45       650
  </code></pre>
  
  <p>The mysql returns the ranking of the country column (1, 2, 3, etc..) and it returned all results EXCEPT the first ranked country. Eg when country=175, should return 1 but no result returned. Direct query via web browser return blank page, no error message. My PHP code</p>
  
  <pre><code>$result = mysql_query("SELECT FIND_IN_SET(clicks,
  (SELECT GROUP_CONCAT(DISTINCT clicks  ORDER BY clicks DESC) 
  FROM countriesRanking)) rank FROM countriesRanking
  WHERE country = '$country'") or die(mysql_error());
  
  $row =  mysql_fetch_assoc($result) or die(mysql_error());
  $theranking = $row['rank'];
  echo $theranking;
  </code></pre>
  
  <p>EDIT</p>
  
  <p>I tried the following but get the same blank page</p>
  
  <pre><code>var_dump($row['rank']);
  </code></pre>
  
  <p>EDIT 2</p>
  
  <p>For a successful query print_r($result) returned something like Resource id #4. While print_r($row) returned Array ( [0] => 4 [rank] => 4 ). But when querying for the top ranking country. eg country=175, it returned a blank page.</p>