PHP / MySQL Error Querying Email Address

Question

I've been trying to query an email address using the following statement, however after hours of trying to escape the string successfully I've accepted defeat.

The query I am using is: SELECT id, email FROM user WHERE email = '$email'

That gives me an error:

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com' at line 1

I'm sure it's simple.. I just can't seem to find an answer anywhere that works.

UPDATE #1

The code that I have been using is:

$email = "[email protected]";

$sql = "SELECT id, email FROM user WHERE email = '$email'";

$result = mysql_query($sql) or die('Unable to connect: '.mysql_error());

UPDATE #2

The email comes from the Facebook connect API.

Please show the full generated query that you are using, and the PHP code — Pekka
– Pekka, Commented Oct 28, 2010 at 11:57
The code you are showing is generating a syntax error ([email protected] needs quotes). Can you show the exact code you are using? Also, please do a echo $sql; for the E-Mail address and show the result. — Pekka
– Pekka, Commented Oct 28, 2010 at 12:05
SELECT id, email FROM user WHERE email = '[email protected]' — lethalMango
– lethalMango, Commented Oct 28, 2010 at 12:08

Pekka · Accepted Answer · 2010-10-28 12:08:06Z

6

This is probably because you the E-Mail address that you get from Facebook connect contains quotes, e.g. something like

"Harry"@gmail.com  
"[email protected]"

when pulling data from a web service (or from anywhere else), you need to escape the data to prevent SQL injection, and garbled queries like in your situation.

In your case:

$email = mysql_real_escape_string($email);

answered Oct 28, 2010 at 12:08

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP / MySQL Error Querying Email Address

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related