Writing a Database Query to a file
<p>I am trying to write a Database Query to a file, But am just wondering how I get the SQL Data to be input into the file.</p>

<p>It is currently outputting nothing to the .txt file at all. I suspect its something to do with the while loop and am questioning whether it needs to be there or not.</p>

<p>My code is :</p>

<pre><code>function backup_tables($host,$user,$pass,$name,$tables = '*')
{

$link = mysql_connect($host,$user,$pass);
mysql_select_db($name,$link);

$query = "SELECT gamename, username, MAX(thescore)
          FROM game_scores
          GROUP BY gamename, username
          ORDER BY gamename, thescore DESC";

$result = mysql_query($query);

while($row = mysql_fetch_array($result)) {
    $scoredata = $row;
}


//save file
$handle = fopen('scores/games-backup'.'.txt','w+');
fwrite($handle,$scoredate);
fclose($handle);

echo "Success";
 }
</code></pre>

<p>Any help on writing the SQL Results to this text file would be much appreciated.</p>
