<?php

$server = "";
$dbuser = "";
$dbpass = "";
$dbname = "";

$fields = "nome, surname, email, sesso, zip, annonascita, cancellare";
$table = "myoutlets";

$ppkkaaaa = date("dmY");

$outputfile = "{$table}_{$ppkkaaaa}.txt";

mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname);

$result = mysql_query("SELECT {$fields} FROM {$table}") or die(mysql_error());

$buffer = "";

while($row = mysql_fetch_assoc($result)) {
    $buffer .= implode("|", $row) . "\n";
}

$pointer = fopen($outputfile, 'w'); or die('Faili loomiseks polnud piisavalt õigusi');
fwrite($pointer, $buffer);
fclose($pointer);

?>