Mailadres of niet? (Opgelost)

<?php
if($_POST[addmail]) // Als addmail wordt gepost...
{
include('connect.php'); // verbinden met database/tabel

$cq = "SELECT * FROM geoffrey WHERE naam = '$_POST[username]' OR email = '$_POST[email]'"; // cq = check query VAR
$check = mysql_query($cq); // check querry uitvoeren; bevat alle rijen waarvan er al een email of naam is
$count = mysql_num_rows($check); // telt dit aantal rijen, als die 1 is is er al een email of naam, dit zou dus 0 moeten zijn

if($count == 0) // als count 0 is
{
$q = "INSERT INTO geoffrey(id,naam,email) VALUES(NULL,'$_POST[username]','$_POST[email]')"; // eerst velden dan waarden.
mysql_query($q); // afwerken querry
echo "E mail submitted"; // bericht na submitten
}
else
{
echo "This email adress or user is already been registraded!"; // bericht als count 1 is
}
}
else
{
?>

<?php
if($_POST[addmail]) // Als addmail wordt gepost...
{
include('connect.php'); // verbinden met database/tabel
 
$cq = "SELECT * FROM geoffrey WHERE naam = '$_POST[username]' OR email = '$_POST[email]'"; // cq = check query VAR
$check = mysql_query($cq); // check querry uitvoeren; bevat alle rijen waarvan er al een email of naam is
$count = mysql_num_rows($check); // telt dit aantal rijen, als die 1 is is er al een email of naam, dit zou dus 0 moeten zijn
 
if($count == 0) // als count 0 is
{
$q = "INSERT INTO geoffrey(id,naam,email) VALUES(NULL,'$_POST[username]','$_POST[email]')"; // eerst velden dan waarden.
mysql_query($q); // afwerken querry
echo "E mail submitted"; // bericht na submitten
}
else
{
echo "This email adress or user is already been registraded!"; // bericht als count 1 is
}
}
else
{
?>

<?php

    require_once 'connect.php';

    if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['addmail'], $_POST['username'], $_POST['email'])) {

        if (preg_match('~^[a-z0-9][a-z0-9_.\-]*@([a-z0-9]+\.)*[a-z0-9][a-z0-9\-]+\.([a-z]{2,6})$~i', $_POST['email']) != 1) {
            
            echo 'The email address is invalid';
            
        } else {
            
            $qCheck = mysql_query("SELECT COUNT(1)
                                   FROM `geoffrey`
                                   WHERE `naam` = '" . mysql_real_escape_string($_POST['username']) . "'
                                   OR `email` = '" . mysql_real_escape_string($_POST['email']) . "'");

            if (mysql_result($qCheck, 0, 0) == 1) {
            
                echo 'The username and/or email address provided has already been registered';
            
            } else {
                
                $qInsertNewSubscription = mysql_query("INSERT INTO `geoffrey` (naam, email)
                                                       VALUES ('" . mysql_real_escape_string($_POST['username']) . "',
                                                               '" . mysql_real_escape_string($_POST['email']) . "')");
                
                echo 'The email address has been registered successfully';
            
            }
            
        }
           
    }

<?php
 
    require_once 'connect.php';
 
    if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['addmail'], $_POST['username'], $_POST['email'])) {
 
        if (preg_match('~^[a-z0-9][a-z0-9_.\-]*@([a-z0-9]+\.)*[a-z0-9][a-z0-9\-]+\.([a-z]{2,6})$~i', $_POST['email']) != 1) {
 
            echo 'The email address is invalid';
 
        } else {
 
            $qCheck = mysql_query("SELECT COUNT(1)
                                   FROM `geoffrey`
                                   WHERE `naam` = '" . mysql_real_escape_string($_POST['username']) . "'
                                   OR `email` = '" . mysql_real_escape_string($_POST['email']) . "'");
 
            if (mysql_result($qCheck, 0, 0) == 1) {
 
                echo 'The username and/or email address provided has already been registered';
 
            } else {
 
                $qInsertNewSubscription = mysql_query("INSERT INTO `geoffrey` (naam, email)
                                                       VALUES ('" . mysql_real_escape_string($_POST['username']) . "',
                                                               '" . mysql_real_escape_string($_POST['email']) . "')");
 
                echo 'The email address has been registered successfully';
 
            }
 
        }
 
    }