title: Pulling data from SQL, and writing to a text file
body: <p>I am trying to pull data from SQL, and then write it to a text file. This does that, to an extent, <strong>but it only pulls 1 from the table, which reads <code>test:test&lt;br&gt;</code></strong> on the text file.</p>
  
  <blockquote>
    <p>I want to be able to pull all the data
    from the table, and then post to the
    text file in a list format such as
    this... </p>
  </blockquote>
  
  <pre><code>    test:test
      test2:test2
      test3:test3
  </code></pre>
  
  <p>I need to find out what I am doing wrong.</p>
  
  <pre><code>&lt;?php
  $sql = mysql_query("SELECT * FROM _$setprofile ORDER BY fc DESC");
  while($row = mysql_fetch_array($sql)){
  $user = $row['user'];
  $pass = $row['pass'];
  
  $accounts = "$user:$pass&lt;br&gt;";
  
  //Functionsss!
  $file = "backups/$newcode.txt";
  file_put_contents($file, $accounts);
  }
  
  echo "&lt;a href=backups/$newcode.txt&gt;TEST!&lt;/a&gt;";
  ?&gt;
  </code></pre>