title: Query not returning correct results in function
body: <p>The following function is set up to:</p>
  
  <ol>
  <li>Collect the <code>user_id</code> from my database, as you can see below <code>WHERE subscriber = '$user'</code>. And then: </li>
  <li>return the possible multiple values that <code>user_id</code> are. </li>
  </ol>
  
  <p>However, when I've tried to use this function, it has only collected an array, with the key <code>0</code>, and value <code>user_id</code>. For apparent reasons I want the array to contain the numerical value that is in the <code>user_id</code> column in my database with the key <code>user_id</code>.</p>
  
  <pre><code>function get_subscribitions($user)
  {
      $user = mysql_real_escape_string ($user);
  
      $sql = "SELECT 'user_id' FROM `subscribe` WHERE subscriber = '$user'";
  
      $result = mysql_query($sql);
  
      $rows = array();
  
      while ($row = mysql_fetch_assoc($result)) {
          $rows[] = $row;
      }
  
      mysql_free_result($result);
  
      return $rows;
  }
  </code></pre>
  
  <p>Can anyone please pinpoint where I'm making the error leading to these related problems?</p>
  
  <p>Any help appreciated, thank you in advance!</p>