title: PHP - Multiple while($row = mysql_fetch_array($variable)) { } ERRORS
body: <p>Okay my syntax can probably be described without the code.  Basically it should be easy...but never is.</p>
  
  <p>I have 2 loops in a row...basically the same thing.  I SELECT * every variable from my database, and then I need to build a 2 layer javascript based on two sep. variables.</p>
  
  <p>So</p>
  
  <p>I have:</p>
  
  <pre><code>while ($row = mysql_fetch_array($myVariable)) {
  
  // do events
  
  }
  </code></pre>
  
  <p>then after that</p>
  
  <pre><code>while ($row2 = mysql_fetch_array($myVariable)) {
  
  // do events
  
  }
  </code></pre>
  
  <p>For some reason it's completely returning NOTHING on the second one...is there some where I need to reset my array, did it possibly end and then I can't just restart.  Such a basic question, but I can't figure out what else could be wrong for the life of me.  So thats the question, is that a general issue to just do that twice in a row and expect PHP to start over each time at the beginning of $myVariable which holds my SELECT statement?</p>
  
  <p>Thanks...will check all day and update as needed.  First timer to Stack Overflow i'd love to see the help.</p>