One more thing! Need help with a timestamp

I just need to have a timestamp when someone posts on my husband's football site. (Like how a guestbook has one.) Here's the code I am using for the site where all results are posted, but the time posts the same for every submission.


mysql_connect("server", "username", "pw") or die("Error: ".mysql_error());
mysql_select_db("eric") or die("Error: ".mysql_error());
extract($_POST); 
$query = "
INSERT INTO 
   `zones`
(name, email, game_one)
    VALUES
('$name', '$email', '$game_one')";
 
$insert = mysql_query($query) or die(mysql_error());
?>
mysql_connect("server", "username", "pw") or die("Error: ".mysql_error());
mysql_select_db("eric") or die("Error: ".mysql_error()); 
$query = "SELECT * FROM `zones`";
$result = mysql_query($query);
while($__row = mysql_fetch_assoc($result)){
    
    echo $__row['name']."
";
    echo $__row['email']."
";    
    echo $__row['game_one']."
";
    echo $today = "Submitted on" ."
".date("D M j G:i:s T Y")."";
}
?>