md5() / encryption in queries

[Anon]

How do I store a hashed/encrypted password in mySQL?

This doesn't work:
$query = "INSERT INTO user (loginid, password) VALUES ('$loginid', '%s')", addslashes(md5($pwd));

What's wrong woth this????

[Anon]

What exactly are you trying to do? Note that your SQL query should obey the rules of your database (MySQL?), not PHP.

I think you want to do something like this:

<%

// PHP CODE
$loginid = sprintf('$loginid', '%s');
$pwd = md5($pwd); // No need to add slashes to a MD5 value

// SQL-COMPLIANT CODE
$query = "INSERT INTO user (loginid, password) VALUES ('$loginid', '$pwd')";

//....etc

?>

[Anon]

Oh! Alright! I thought it works like C. Thanks!!!

[Anon]

I'm not a coder, but I need to convert ALL of my users' passwords with md5. Currently, I have all the user info in an Excel spreadsheet, which I'll dump into a text file and upload to a mySQL table.

Can someone help me with a quick PHP script to query all the user records, then convert ALL the passwords with md5?

Or, if anyone knows of a utility or function to use in Excel to do the same thing, that would be just as useful, if not more so.

Thanks for any help!

Billy Hotchkiss