mysql & emails

[Eggzorcist]

I'm trying to do a query as such:

SELECT * FROM projects WHERE user = {$user}

 

and $user = a secured email. but I'm getting this 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

 

 

Why am I getting this error?

 

Thank you very much!

[DavidAM]

If the user column is not a number type, you have to put the string you are looking for in quotes:

 

SELECT * FROM projects WHERE user = '{$user}'