script import niet

[fonville]

ik heb een script maar de gegevens worden niet in mijn database geupload

script:

<?
$formulier .= '<form method=post acion="">
<table>
   <tr>
      <td>
         <font face=verdana size=1>gebruikersnaam:
      </td>
      <td>
         <input type="text" name="name" maxlength="15">
      </td>
   </tr>
   <tr>
   <td>
   voornaam: 
      </td>
   <td>
   <input type="text" name="vnaam" maxlength="15">
   </td>
   </tr>
      <tr>
   <td>
   achternaam: 
   </td>
   <td>
   <input type="text" name="anaam" maxlength="15">
   </td>
   </tr>
   <tr>
   <td>
   <font face=verdana size=1>email:
   </td>
   <td>
   <input type="text" name="email">
   </td>
   </tr>
   <tr>
      <td>
         <font face=verdana size=1>wachtwoord:
      </td>
      <td>
         <input type="password" name="pass1">
      </td>
   </tr>
   <tr>
      <td>
         <font face=verdana size=1>herhaal wachtwoord:
      </td>
      <td>
            <input type="password" name="pass2">
      </td>
   </tr>
<tr>
<td>
   </td>
   <td>
<input type="checkbox" name="brief" value="brief" /> ik wil me aan melden voor de nieuws brief
 </td>
 </tr>
   <tr>
      <td>
	     </td>
   <td>
         <input type="submit" value=registreer name="submit">
         <input type="reset">
      </td>
   </tr>
</table>
</form>';

if(isset($_REQUEST['submit'])){
   //request everything
   $dead = "false";//We make 'dead' if some fields are not filled in don't check for pass and name in db.
   $message = "<font face=verdana size=1>vul alle velden goed in:<br>";
   $username = $_POST['name'];
   $vnaam = $_POST['vnaam']; 
   $anaam = $_POST['anaam'];
   $email = $_POST['email'];
   $pass1 = $_POST['pass1'];
   $pass2 = $_POST['pass2'];
   //begin search for errors
   if(strlen($username)  <= 2 or strlen($username) >= 14){
      $dead = "true";
      $message = "je gebruikersnaam is te kort of te lang(2-14)<br>";

   }

   if($pass1 !== $pass2){
		$dead = "true";
		$message = "de 2 wachtwoorden zijn niet het zelfde";
		}
	if(strlen($pass1) <= 6 or strlen($pass1) >= 20) {
      $dead = "true";
      $message = "je wachtwoord is te kort of te lang(6-20) ";
   } 
   if($dead == "false"){
$database ="********";
$server ="********";
$user ="*******";
$passw ="******";
mysql_connect("$server","$user", "$passw") or die (mysql_error()); 
mysql_select_db($database) or die (mysql_error());
      $username = strtolower(trim(strip_tags($username)));
      $pass1 = trim($pass1);
      $pass1 = md5($pass1);
      $query = mysql_query("SELECT * FROM members WHERE username ='$username'") or die (mysql_error());
      $aantalrijen = mysql_num_rows($query) or die (mysql_error());                   
      if($aantalrijen == 1){         
         print "<font face=verdana size=1>Sorry, je gebruikers naam is al geregistreert."; 

      }
      else{
	  $nee = 'nee';
         $query1 = "INSERT INTO members(username, password, admin, voornaam, achternaam, email) VALUES ('$username','$pass1','$nee','$vnaam','$anaam','$email') or die (mysql_error())" ;
         if(mysql_query($query1)){
             print "<font face=verdana size=5>je bent succesvol geregistreert.";
         }   
      }
      
   }
   elseif($dead == "true"){
         print $message;

   }
   if($dead == "true"){
   		echo $formulier;}
 if(isset($_POST['brief'])){
 $database ="*******";
$server ="*********";
$user ="******";
$passw ="********";
mysql_connect("$server","$user", "$passw") or die (mysql_error()); 
mysql_select_db($database) or die (mysql_error());
      $query = mysql_query("SELECT * FROM brief WHERE naam ='$username'");
      $aantalrijen = mysql_num_rows($query);                   
      if($aantalrijen == 1){
	  }
	  else{
mysql_query("INSERT INTO brief(naam, email) VALUES ('$username','$email')") or die (mysql_error()); 
}
}  
}
else{
echo $formulier;}            
?>

sql:

CREATE TABLE `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(99) COLLATE latin1_general_ci NOT NULL,
  `password` varchar(99) COLLATE latin1_general_ci NOT NULL,
  `admin` varchar(99) COLLATE latin1_general_ci NOT NULL,
  `voornaam` varchar(99) COLLATE latin1_general_ci NOT NULL,
  `achternaam` varchar(99) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(99) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;