oke klaar bet debuggen dit is het geworden:
aanmelden.php:
<?
error_reporting(E_ALL);
require ('config.php');
if(isset($_POST['submit']))
{
$query = mysql_query("SELECT * FROM members WHERE gebruikersnaam = '".$_POST['gebruikersnaam']."'");
$result = mysql_num_rows($query);
if($result >= 1)
{
echo 'De door jou gekozen gebruikersnaam wordt al door iemand anders gebruikt.<br /><br /><a href="javascript:history.go(-1)">Ga terug</a>';
}else{
if(!empty($_POST['naam']) AND !empty($_POST['email']) AND !empty($_POST['gebruikersnaam']) AND !empty($_POST['geslacht']) AND !empty($_POST['land']) AND !empty($_POST['geb1']) AND !empty($_POST['geb2']) AND !empty($_POST['geb3']))
{
echo 'Er zijn nog open velden<br /><br /><a href="javascript:history.go(-1)">Ga terug</a>';
}else{
if($_POST['wachtwoord'] != $_POST['wachtwoord2'])
{
echo 'De wachtwoorden zijn niet het zelfde<br /><a href="javascript:history.go(-1)">Ga terug</a>';
}else{
$geb1 = $_POST['geb1'];
$geb2 = $_POST['geb2'];
$geb3 = $_POST['geb3'];
$geboortedatum = ''.$geb1.'-'.$geb2.'-'.$geb3;
$gebruikersniveau = 1;
$activeringscode = 1;
$sql = mysql_query("INSERT INTO members (gebruikersnaam,wachtwoord,naam,email,geboortedatum,gebruikerniveau,country,geslacht,geactiveerd) VALUES ('".$_POST['gebruikersnaam']."','".$_POST['wachtwoord']."','".$_POST['naam']."','".$_POST['email']."','".$geboortedatum."','".$gebruikersniveau."','".$_POST['country']."','".$_POST['geslacht']."','".$activeringscode."')") or die(mysql_error());
echo 'Je acount is gemaakt je kunt je vanaf nu inloggen met je gegevens';
}
}
}
}else{
?>
<form method="POST" action="index.php?page=register">
<p>
</p>
<table width="334" cellpadding="0" cellspacing="0">
<tr>
<td width="142" valign="top"><p>Naam: </p></td>
<td width="190" valign="top"><p>
<input type="text" name="naam" size="30">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Email: </p></td>
<td width="190" valign="top"><p>
<input type="text" name="email" size="30">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Username: </p></td>
<td width="190" valign="top"><p>
<input type="text" name="gebruikersnaam" size="25">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Password: </p></td>
<td width="190" valign="top"><p>
<input type="password" name="wachtwoord" size="12" maxlength="12">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Opnieuw Password: </p></td>
<td width="190" valign="top"><p>
<input type="password" name="wachtwoord2" size="12" maxlength="12">
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Geslacht: </p></td>
<td width="190" valign="top"><p>
<select size="1" name="geslacht">
<option value="Man">Man</option>
<option value="Vrouw">Vrouw</option>
</select>
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Land: </p></td>
<td width="190" valign="top"><p>
<select name="country">
<option value="Afganistan">Afganistan</option>
<option value="Albania ">Albania</option>
<option value="Algeria">Algeria</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antarctica ">Antarctica</option>
<option value="Antigua ">Antigua</option>
<option value="Argentina ">Argentina</option>
<option value="Armenia">Armenia</option>
<option value="Aruba ">Aruba</option>
<option value="Australia ">Australia</option>
<option value="Austria ">Austria</option>
<option value="Azerbaijan">Azerbaijan</option>
<option value="Bahamas">Bahamas</option>
<option value="Bahrain ">Bahrain</option>
<option value="Barbados ">Barbados</option>
<option value="Bangladesh">Bangladesh</option>
<option value="Belarous">Belarous</option>
<option value="Belgium ">Belgium</option>
<option value="Belize">Belize</option>
<option value="Benin ">Benin</option>
<option value="Bermuda">Bermuda</option>
<option value="Bhutan ">Bhutan</option>
<option value="Botswana">Botswana</option>
<option value="Bolivia">Bolivia</option>
<option value="Bosnia">Bosnia</option>
<option value="Bouvet Island ">Bouvet Island</option>
<option value="Brazil">Brazil</option>
<option value="Brunei Darussalam ">Brunei Darussalam</option>
<option value="Bulgaria">Bulgaria</option>
<option value="Burkina Faso">Burkina Faso</option>
<option value="Burundi">Burundi</option>
<option value="Canada">Canada</option>
<option value="Cambodia">Cambodia</option>
<option value="Cameroon">Cameroon</option>
<option value="Cape Verde ">Cape Verde</option>
<option value="Cayman Islands ">Cayman Islands</option>
<option value="Central Aferican Republic">Central Aferican Republic</option>
<option value="Chad">Chad</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Christmas Island">Christmas Island</option>
<option value="Cocos Islands ">Cocos Islands</option>
<option value="Columbia">Columbia</option>
<option value="Comoros">Comoros</option>
<option value="Congo">Congo</option>
<option value="Congo, Democratic Republic">Congo, Democratic Republic</option>
<option value="Cook Islands">Cook Islands</option>
<option value="Costa Rica">Costa Rica</option>
<option value="Ivory Coast">Ivory Coast</option>
<option value="Croatia">Croatia</option>
<option value="Cuba ">Cuba</option>
<option value="Cyprus">Cyprus</option>
<option value="Czech Republic">Czech Republic</option>
<option value="Denmark">Denmark</option>
<option value="Djibouti">Djibouti</option>
<option value="Dominica">Dominica</option>
<option value="Dominican Republic">Dominican Republic</option>
<option value="East Timor">East Timor</option>
<option value="Ecuador">Ecuador</option>
<option value="Egypt">Egypt</option>
<option value="El Salvador ">El Salvador</option>
<option value="Equilateral Guinea">Equilateral Guinea</option>
<option value="Eritrea">Eritrea</option>
<option value="Estonia">Estonia</option>
<option value="Ethiopia">Ethiopia</option>
<option value="Falkland Islands">Falkland Islands</option>
<option value="Faroe Islands">Faroe Islands</option>
<option value="Fiji">Fiji</option>
<option value="Finland">Finland</option>
<option value="France">France</option>
<option value="French Guiana">French Guiana</option>
<option value="French Polynesia">French Polynesia</option>
<option value="Macedonia">Macedonia</option>
<option value="Gabon">Gabon</option>
<option value="Gambia">Gambia</option>
<option value="Georgia">Georgia</option>
<option value="Germany">Germany</option>
<option value="Ghana">Ghana</option>
<option value="Gibralter">Gibralter</option>
<option value="Great Britain">Great Britain</option>
<option value="Greece">Greece</option>
<option value="Greenland">Greenland</option>
<option value="Grenada">Grenada</option>
<option value="Guadeloupe">Guadeloupe</option>
<option value="Guam">Guam</option>
<option value="Guatemala">Guatemala</option>
<option value="Guinea">Guinea</option>
<option value="Guinea-Bissau">Guinea-Bissau</option>
<option value="Guyana">Guyana</option>
<option value="Haiti">Haiti</option>
<option value="Honduras">Honduras</option>
<option value="Hong Kong">Hong Kong</option>
<option value="Hungary">Hungary</option>
<option value="Iceland">Iceland</option>
<option value="India">India</option>
<option value="Indonesia">Indonesia</option>
<option value="Iran">Iran</option>
<option value="Iraq">Iraq</option>
<option value="Ireland">Ireland</option>
<option value="Israel">Israel</option>
<option value="Italy">Italy</option>
<option value="Jamaica">Jamaica</option>
<option value="Japan">Japan</option>
<option value="Jordan">Jordan</option>
<option value="Kazakhstan">Kazakhstan</option>
<option value="Kenya">Kenya</option>
<option value="Kiribati">Kiribati</option>
<option value="Korea, North">Korea, North</option>
<option value="Korea, South">Korea, South</option>
<option value="Kuwait">Kuwait</option>
<option value="Laos">Laos</option>
<option value="Lativa">Lativa</option>
<option value="Lebanon">Lebanon</option>
<option value="Liberia">Liberia</option>
<option value="Libya">Libya</option>
<option value="Lesotho">Lesotho</option>
<option value="Lithuania">Lithuania</option>
<option value="Luxembourg">Luxembourg</option>
<option value="Macau">Macau</option>
<option value="Madagascar">Madagascar</option>
<option value="Malawi">Malawi</option>
<option value="Malaysia">Malaysia</option>
<option value="Maidives">Maidives</option>
<option value="Mali">Mali</option>
<option value="Malta">Malta</option>
<option value="Marshal Islands">Marshal Islands</option>
<option value="Martinique">Martinique</option>
<option value="Mauritania">Mauritania</option>
<option value="Mauritius">Mauritius</option>
<option value="Mayotte">Mayotte</option>
<option value="Mexico">Mexico</option>
<option value="Micronesia">Micronesia</option>
<option value="Monaco">Monaco</option>
<option value="Moldovia">Moldovia</option>
<option value="Morocco">Morocco</option>
<option value="Mongolia">Mongolia</option>
<option value="Montserrat">Montserrat</option>
<option value="Mozambique">Mozambique</option>
<option value="Myanmar">Myanmar</option>
<option value="Nambia">Nambia</option>
<option value="Nauru">Nauru</option>
<option value="Nepal">Nepal</option>
<option value="Netherlands">Netherlands</option>
<option value="Netherlands Antillies">Netherlands Antillies</option>
<option value="New Calidonia">New Calidonia</option>
<option value="New Zealand">New Zealand</option>
<option value="Nicaragua">Nicaragua</option>
<option value="Niger">Niger</option>
<option value="Nigeria">Nigeria</option>
<option value="Niue">Niue</option>
<option value="Norfold Island">Norfold Island</option>
<option value="Northern Mariana Islands">Northern Mariana Islands</option>
<option value="Norway">Norway</option>
<option value="Oman">Oman</option>
<option value="Pakistan">Pakistan</option>
<option value="Palau">Palau</option>
<option value="Panama">Panama</option>
<option value="Papau New Guinea">Papau New Guinea</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Phillipines">Phillipines</option>
<option value="Pitcairn">Pitcairn</option>
<option value="Poland">Poland</option>
<option value="Portugal">Portugal</option>
<option value="Puerto Rico">Puerto Rico</option>
<option value="Qatar">Qatar</option>
<option value="Reunion">Reunion</option>
<option value="Romania">Romania</option>
<option value="Russian Federation">Russian Federation</option>
<option value="Rwanda">Rwanda</option>
<option value="Sandwich Islands">Sandwich Islands</option>
<option value="Saint Kitts">Saint Kitts</option>
<option value="Saint Lucia">Saint Lucia</option>
<option value="Saint Vincent">Saint Vincent</option>
<option value="Samoa">Samoa</option>
<option value="San Marino">San Marino</option>
<option value="Sao Tome">Sao Tome</option>
<option value="Saudi Arabia">Saudi Arabia</option>
<option value="Senegal">Senegal</option>
<option value="Seychelles">Seychelles</option>
<option value="Sierra Leone">Sierra Leone</option>
<option value="Singapore">Singapore</option>
<option value="Slovenia">Slovenia</option>
<option value="Slovak Republic">Slovak Republic</option>
<option value="Soloman Islands">Soloman Islands</option>
<option value="Somalia">Somalia</option>
<option value="South Africa">South Africa</option>
<option value="Spain">Spain</option>
<option value="Sri Lanka">Sri Lanka</option>
<option value="St, Helena">St, Helena</option>
<option value="Sudan ">Sudan</option>
<option value="Suriname">Suriname</option>
<option value="Svalbard">Svalbard</option>
<option value="Swaziland">Swaziland</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="Syria">Syria</option>
<option value="Taiwan">Taiwan</option>
<option value="Tajikistan">Tajikistan</option>
<option value="Tanzania">Tanzania</option>
<option value="Thailand">Thailand</option>
<option value="Togo">Togo</option>
<option value="Tokelau ">Tokelau</option>
<option value="Tonga">Tonga</option>
<option value="Trinidad ">Trinidad</option>
<option value="Tunisia">Tunisia</option>
<option value="Turkey ">Turkey</option>
<option value="Turkmenistan">Turkmenistan</option>
<option value="Caicos Islands">Caicos Islands</option>
<option value="Tuvalu ">Tuvalu</option>
<option value="Uganda">Uganda</option>
<option value="Ukraine">Ukraine</option>
<option value="United Arab Emirates">United Arab Emirates</option>
<option value="United Kingdom">United Kingdom</option>
<option value="United States">United States</option>
<option value="US Minor Outlying Islands">US Minor Outlying Islands</option>
<option value="Uruguay">Uruguay</option>
<option value="Uzbekistan">Uzbekistan</option>
<option value="Vanuatu">Vanuatu</option>
<option value="Vatican City State">Vatican City State</option>
<option value="Venezuela">Venezuela</option>
<option value="Viet Nam">Viet Nam</option>
<option value="Virgin Islands (British)">Virgin Islands (British)</option>
<option value="Virgin Islands (US)">Virgin Islands (US)</option>
<option value="Wallis and Fortuna Islands">Wallis and Fortuna Islands</option>
<option value="West Sahara">West Sahara</option>
<option value="Yemen">Yemen</option>
<option value="Yugoslavia">Yugoslavia</option>
<option value="Zambia ">Zambia</option>
<option value="Zimbabwe">Zimbabwe</option>
</select>
</p></td>
</tr>
<tr>
<td width="142" valign="top"><p>Geboorte Datum: </p></td>
<td width="190" valign="top"><p>
<select name="geb1">
<?
for ($i=1;$i<32;$i++){
echo '<option value='.$i.'>'.$i.'</option>';
}
echo '</select>';
echo '<select name="geb2">';
for ($i=1;$i<13;$i++){
echo '<option value='.$i.'>'.$i.'</option>';
}
echo '</select>';
echo '<select name="geb3">';
for ($i=1900;$i<2007;$i++)
{
echo '<option value='.$i.'>'.$i.'</option>';
}
echo '</select> ';
?>
</p></td>
</tr>
<tr>
<td width="334" height="24" valign="top">
<input type="submit" name="submit" value="Sign Up!">
</td>
</tr>
</table>
</form>
<? } ?>
