Oh, and if you wanted to do it after you inserted, you could just do: mysql_query("UPDATE tablename SET pwfieldname = md5(pwfieldname);");
On Wed, 2002-10-09 at 08:39, Verdon Vaillancourt wrote: > Hi, > > I hope this question isn't too basic... > > I have a flat file (CSV) that I want to import into a mySQL db via > phpMyAdmin. The file has about 1200 rows and is in a format like: > "value","value","password","value","value","etc" > The passwords are in clear text. I need them to be encrypted in md5. > > Is there any advice out there as to how I could process this flat-file > before I import into my db or after the fact? > > Thanks, verdon > Ps. Please cc me if replying to list as I am on digest mode > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php