title: SQL only retrieve first item in the database
body: <pre><code>$search = mysql_query("SELECT subject FROM book WHERE useid = $userid") or die(mysql_error());
  $sub = mysql_fetch_array($search, MYSQL_ASSOC);
  print_r($sub);
  </code></pre>
  
  <p>There's a lot of subject in the book table with same user id, but it only retrieve first of it, why is that so?</p>