title: mysql_fetch_assoc fetching only one record
body: <p>I have an array with the result of a query:</p>
  
  <pre><code>.....some code.....
  $result = mysql_query("SELECT * FROM vttest");
  $row = mysql_fetch_assoc($result);
  print_r($row);
  </code></pre>
  
  <p>But it only prints one record, I can't put $row in a loop because I will be working on sorting that variable later.</p>
  
  <pre><code>Array
  (
      [id] =&gt; 3
      [rep] =&gt; Mike
      [name] =&gt; Joe
      [department] =&gt; Business
      [location] =&gt; Room 1
      [email] =&gt; xxxx@hotmail.com
      [phone] =&gt; 519-123-4567
      [type] =&gt; Visit
      [drink] =&gt; Coffee
      [notes] =&gt; Some notes
      [lastVisited] =&gt; 2010-08-27
      [nextVisit] =&gt; 2010-08-27
  )
  </code></pre>
  
  <p>I know there are more records than that, how can I print all of it while still being able to work with the $row variable?</p>