[Resolved] Will this query work?

[Napster]

Assuming all the information is correct and such, will this query work? If no, how can I do it properly?

mysql_query("UPDATE members SET verify = '1' WHERE username = '" . md5($username) . "'") or die(mysql_error());

[bretticus]

Looks good to me. it will work just fine as long as the password was encoded with MD5 before it went into the database.

[Napster]

Shoot, I meant to go:

  mysql_query("UPDATE members SET verified = '1' WHERE md5(username) = '$id'") or die(mysql_error());

[mtmosier]

Should work fine as long as you have mysql 3.23.2 or later.

[Napster]

Yep it worked. Thank you.