Need small help to select md5 hash field

red_wolf · August 19, 2012, 8:13pm

This what i have:
[php]
$q = mysql_query(“SELECT email FROM users WHERE email=’(md5($email))’”);
[/php]
Not work what to use instead?

wilson382 · August 19, 2012, 8:18pm

Hello

[php]
$q = mysql_query(“SELECT email FROM users WHERE email=’”.md5($email)."’");
[/php]

OR

[php]
$md5_email =md5($email);
$q = mysql_query(“SELECT email FROM users WHERE email=’$md5_email’”);
[/php]

let know which one worked for you

red_wolf · August 20, 2012, 12:27am

Thank you so much!
don’t know why i don’t found this before. thanks!

wilson382 · August 20, 2012, 12:35am

I marked the thread solved.

Your welcome

happy coding