Forgot Password / Register
Site Statistics
Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 81
0 Users 4 Guests Online
Forum Index » PHP + MySQL » Member System - Not allowing u
Posted on Saturday 12th May 2007 at 09:18 PM
Diablosblizz
templates/default/images/noavatar.png's Avatar
Senior Member
Title says it all!

Am I able to make a code that doesn't allow a member to use the same email twice?

Thanks.
Posted on Saturday 12th May 2007 at 09:30 PM
SkillMaster
templates/default/images/noavatar.png's Avatar
Senior Member
Code

<?php
include ("config.php");

$email = ("$_GET[email]");

$query = mysql_query("SELECT `email` FROM `members` WHERE email='$email'");
$checkemail = mysql_num_rows($query);
if ($checkemail>0)
{
echo ("That email is already in use");
}
?>


You're smart, work it out.
Posted on Saturday 12th May 2007 at 09:42 PM
Diablosblizz
templates/default/images/noavatar.png's Avatar
Senior Member
You're smart, work it out.


I AM I WILL DO IT :D.

Thanks!
Posted on Saturday 12th May 2007 at 09:59 PM
SkillMaster
templates/default/images/noavatar.png's Avatar
Senior Member
I meant, figure out where to put it
Posted on Monday 28th May 2007 at 05:41 PM
MCP
templates/default/images/noavatar.png's Avatar
Junior Member
lol It's easy enough to figure out.
Posted on Wednesday 30th May 2007 at 08:58 PM
SkillMaster
templates/default/images/noavatar.png's Avatar
Senior Member
Yes not hard?