Select Problem

Anon

PHP script enters form data into MySql db for registration of new users. Script checks email address formatting, checks for blank or duplicate usernames/email addresses. If dupes or blanks -- error try again.

User can't register without email address but some prospective users will have no email address. So, there's an "admin" email address they can use instead -- then they're registered but not activated. Admin is notified by email and activates account.

Problem: To check for dupe email addresses, script counts matches where email = '$email'-- this prevents dual registering but disables the use of the admin email address. The code for checking for dupes is:

$EmailQuery = mysql_query("SELECT * FROM signup WHERE email='$email'");
$email = strtolower($email);
$EmailExist = mysql_num_rows($EmailQuery);

Question: Is there a way to change the select statement so that the admin email address will not be counted as existing? Will appreciate very much any help at all.

Thanks, Naporan

Anon

Naporan,

Easiest way is probably to put an IF statement in you PHP code.

e.g.

$email = strtolower($email);
if ( $email !== "admin email address")
{
mysql_query("SELECT * FROM signup WHERE email='$email'");
$EmailExist = mysql_num_rows;
}
else
{
$EmailExist = 0;
}

Cheers,

Justin

P.s. hope you have an appropriate index on your email field.

Anon

Justin,

Thanks very much for your help. With slight adjustment, I followed your suggestions, and now the form takes registrations from those with and without email addresses. The db table will hold only about 200 registrations, so it seems that indexing isn't as important as it could be.

I need only one more step to finish this off. There is another table for this group of scripts named "checkit." I need to get the script to check with the table checkit to verify that the form submitted first and last names are on the checkit table -- unless you're an employee, you can't register for these secure pages. -- and if the submitted first/last names are not in checkit, then exit with error page, else continue.

Any suggestions for this part? And thanks already for your help.

Naporan