Php Mysql query - If number of results is over X display error - help?

[demeiz_88]

Basically, I want a user to be able to register with the same email address a maximum of 7 times.
What sort of code would i need to use?

Currently i have:

// Process email address.
if ($email1 == "") { $errors++; $errorlist .= "Email field is required.<br />"; }
if (! is_email($email1)) { $errors++; $errorlist .= "Email isn't valid.<br />"; }
$emailquery = doquery("SELECT email FROM {{table}} WHERE email='$email1' LIMIT 1","users");