Error in php/MySQL query?

Tutorialized Forums Sponsor:

March 4th, 2008, 09:34 AM

yoyo888

Registered User

Join Date: Mar 2008

Posts: 2

Time spent in forums: 5 m 52 sec
Reputation Power: 0

Error in php/MySQL query?

Hello,
I have this query to find out whether the email address the user typed in, already exists in the database.

if($res=mysql_query("SELECT address FROM email WHERE address ='{$new_emailaddress}'") <>FALSE) {
echo "This email address already exists . Enter a new one.";}

the problem is, the query always returns true. But I want to compare it to the email address the user enters.

Can anyone help me?

March 13th, 2008, 12:05 PM

mwasif

Contributing User

Join Date: Apr 2007

Location: Saudi Arabia

Posts: 7

Time spent in forums: 30 m 35 sec
Reputation Power: 0

I am assuming user provided email is in $new_emailaddress.

PHP Code:


		
			
 $res=mysql_query("SELECT address FROM email WHERE address ='$new_emailaddress'");

if(mysql_num_rows($res)>0){

echo "This email address already exists . Enter a new one.";

}

Viewing: Tutorialized Forums > Databases > MySQL > Error in php/MySQL query?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump