mysql query doesn't like @'s

[DaveR]

ok this is the error I'm getting :-(

error 1064: You have an error in your SQL syntax near '@dm3ds.com ORDER BY user_index' at line 1

this is my query string

SELECT user_index,date_added,valid,last_name,first_name,password,email,nicname,org_url,per_url,short_bio,long_bio,rnameok,email_yn FROM members WHERE email = [e-mail] ORDER BY user_index

this fails

yet I can query any of the other fields without any problems but it seems it doesn't like the @ when I try to find the email address.

How do I get around this problem.

Sadly to say I know enough about php & mysql to shoot myself in the foot.

DaveR

[RedDragon]

try

SELECT user_index,date_added,valid,last_name,first_name,p
assword,email,nicname,org_url,per_url,short_bio,lo
ng_bio,rnameok,email_yn FROM members WHERE email = '[e-mail]' ORDER BY user_index