posted April 24, 2000 12:57 AM            

"SELECT * FROM members WHERE email='shiju@post.com'"

if return value is greater than 0 then the email address is existing in the database.else , not existing in the database.

posted April 26, 2000 12:31 AM            

$con=mysql_connect('localhost','username','password');

mysql_select_db ('databasename',$con);

$result = mysql_query("SELECT * FROM members WHERE email='$email'",$con);

if (mysql_num_rows($result) == 1)
{
# email is existing in the database
$emailexists = 1;
}else{
#Email is not existing...
exit;
}

GOOD LUCK!!

posted April 29, 2000 02:28 AM            

"select * from member where email=$email";

can't it be just simple like

$result="select count(email) as xyz from member where email=$email";

$xyz=mysql_result($result,0,"xyz");

if($xyz)
{
echo "user email exists allready";
//or do whatever
}
else
{
echo "user available";
//ur processing
}

ranjeet

posted April 29, 2000 05:16 AM            

"select email from member where email=$email";

this query will return the no of rows.if no of rows is greater 0 then offcourse the email is existing.

see.. for easy understanding i written that very straight.

What you are writing also is very fine.But you are doing that in different way.

Thank You.

posted April 29, 2000 06:07 AM            

but in ur reply u had given

"select * from member where email=$email";

instead of

"select email from member where email=$email"