title: How to retrieve multiple results ( ids ) in a query
body: <p>I want to retrieve multiple results but currently only getting one result, here is my current code: </p>
  
  <pre><code>$p_user = $prodata-&gt;user_id;
  $usx = $user-&gt;getdb()-&gt;query("SELECT `user_one`, `user_two` FROM `friends` WHERE `user_one`= ? OR `user_two`= ? ", array($p_user, $p_user));
  
  $count_frnds = $usx-&gt;count();
  if(!$usx-&gt;count()){
      echo 'error';
  }else {
      foreach($usx-&gt;results() as $use){
          $use-&gt;user_one;
          $use-&gt;user_two;
          if($p_user == $use-&gt;user_one){
              $can = $use-&gt;user_two;
          }else {
              $can = $use-&gt;user_one;
          }
  
       }
  }
  
  echo $can; //want multiple results, but only returns one result.
  </code></pre>