title: Multiple PHP WHILE loops using the same query
body: <pre><code>$query1 = "SELECT * FROM idevaff_affiliates";
  $affiliateID = mysql_query($query1) or die(mysql_error());
  </code></pre>
  
  <p>This is my query above - I would like to use it for two WHILE loops </p>
  
  <p>The first one is in the header section - setting up jquery   </p>
  
  <pre><code>while($row = mysql_fetch_assoc($affiliateID)){
  }
  </code></pre>
  
  <p>The second is used in a while loop in the body  </p>
  
  <pre><code>while($row = mysql_fetch_assoc($affiliateID)){
  }
  </code></pre>
  
  <p>Why can't I get it to work? - I did get it working but had to make two queries using the same SELECT info using two different variables.</p>