User confirmation link email issue

[eluser]Xeroxeen[/eluser]
[quote author="Pert" date="1371626306"]Looks like you're putting quotes around the query and it doubles up. Try this instead (no single quotes around ?)

Code:

$val_code = "SELECT email FROM `users` WHERE hash=?";

[/quote]

Thank you very much.Now it's working. I removed single quotations around hash and checked.But it didn't worked.Then i removed MD5 part also.Then it woked.Anyway i really appreciate your solution and this forum is really helpful.Thanks again